All geek questions in one place

Automatically increase sheet link when dragging formulas

I have a formula with the following syntax:

=SheetName!E10

and you need to somehow drag the formula and change only the sheet name when it moves to the right. Thus, part of E10 should remain unchanged as the number of sheets increases as you drag the formula. We have many rows and columns, and this will certainly speed us up.

Is it possible?

Thus, the result will look like this:

 =Sheet1!E10 =Sheet2!E10 =Sheet3!E10

This is the result:

SO26599056 question example

from applying this formula:

 =INDIRECT("mo"&COLUMN()+0&"!B4")
+6
source share
1 answer

Try:

 =INDIRECT("Sheet"&COLUMN()+x&"!E10")

where x is the offset returning the corresponding number (Column () + x), wherever you choose to place the formula.

Modify to combine subsequent details with the image (where 5 may be in column B) and the comment may need to be:

 =INDIRECT("mo"&COLUMN()-1&"!E10")
+7
source

Source: https://habr.com/ru/post/977309/

More articles:


All Articles