Forum Discussion
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...
Hi Nir,
Why don't you return the name directly by formula, like
=INDEX($C$8:$C$13,MATCH(G8,D8:$D$13,0))
If through the cell with address (B10 I guess) that will be
=INDIRECT(B10)
oh man, so perfect.
Thanks so much!
Thanks so much!