CODEWITHSUNDEEP
exceldynamicrangecell
user3316593
user3316593

Reputation: 3

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 ?

Upvotes: 0

Views: 64

Answers (1)

CRondao
CRondao

Reputation: 1903

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

Assuming values are in C1 and down

Upvotes: 1

Related Questions