CODEWITHSUNDEEP
excelworksheet-function
Yoot
Yoot

Reputation: 235

Dynamic cell access

My question may seem quite simple but I haven't found the answer yet.

In excel, I would like to access a cell with a dynamic row number.

Example 1 : cell A(1+2)
Example 2 : cell B(ROW(A1)*10)

What is the syntax for this ?

Thanks.

Upvotes: 22

Views: 26369

Answers (2)

Excellll
Excellll

Reputation: 5785

Use the INDIRECT function:

=INDIRECT("A" & (1+2))
=INDIRECT("B" & ROW(A1)*10)

Upvotes: 37

brettdj
brettdj

Reputation: 55672

If by cell B(ROW(A1)*10) you meant if A1 was 3 then return the value in B30 ,ie B(3*10)

then you want =INDIRECT("B" &A1*10)

=INDIRECT("B" & ROW(A1)*10) will always return cell B10 as ROW(A1) always =1

Upvotes: 1

Related Questions