Search code examples
exceldynamicrangecell

Dynamic row in a cell sequence

I need some help with a formula reference.

For example, I have a formula A1=sheet!$B20. Then on the next row I need it to be A2=sheet!$B47, then A3=sheet!$B74... etc.

The reference cells - 20, 47, 74 etc. - I have in another column from which I want to read the numbers and when I drag the formula from A1 downwards I would like the formula to take these values automatically.

How can I do that ?

Solution 
  • =INDIRECT("sheet!$B" & C1)

    Assuming values are in C1 and down