Forum Discussion
Nir Yogev
May 03, 2018Copper Contributor
question about address formula
Hi I would like to know how can a get the value of a cell based on its position to another cell with address. for example, in this table I've written a formula that shows the address of the highest r...
Jonathan Cooper
May 03, 2018Copper Contributor
Assuming your $D$13 is in cell B10 then use: =OFFSET(INDIRECT(B10),,1)