Hi!
I'm trying to see if there is a way where I can link a cell, but with a dynamic reference?
cell A1:
=B1+C1
Can I change this, so that B1 becomes dynamic looks up what cell to use by reading the row and column from to different cells?
(the column would be stored in A2, and the rownum would be stored in A3)
- A B C D 1 =(A2 value & A3 value(B1)) 1 1 2 B 3 1 4
Thanks you your help!
Bookmarks