=INDIRECT("A"&(MATCH(B10,B2:B5,1)+1))

--
Kind regards,

Niek Otten

"Daminc" wrote in
message ...

I sure it's quite simple but I'm having all sorts of problems with
this:

Background:

one cell gives me the MAX value of a range of cells
I want to then use that value to refer back to the range of cells and
return the value one column to the left

This formula returns "A4" which is the cell number for this result I
want to show but it just enters A4 not the contents of cell A4

="A"&(MATCH(B10,B2:B5,1)+1)

does that make sense?


--
Daminc
------------------------------------------------------------------------
Daminc's Profile:
http://www.excelforum.com/member.php...o&userid=27074
View this thread: http://www.excelforum.com/showthread...hreadid=483454