question about address formula

Question

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 rank in the table. I need to know how can I build a formula in a different cell that shows me the name of the highest rank (Steve) based on the address ($d$13). Can you please help? Thanks in advance...

sergeibaklan · Answer

Hi Nir,
&nbsp;
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&nbsp;I guess) that will be
=INDIRECT(B10)
&nbsp;

logaraj sekar · Answer

&nbsp;Hi&nbsp;Nir Yogev&nbsp;=INDEX(E8:E13,MATCH(MAX(D8:D13),D8:D13,0),1)

nir yogev · Answer

oh man, so perfect.Thanks so much!

nir yogev · Answer

oh man, so perfect.Thanks so much!

jonathan cooper · Answer

Assuming your $D$13 is in cell B10 then use:&nbsp; =OFFSET(INDIRECT(B10),,1)

Forum Discussion

question about address formula

Share

Resources