Ooops: typo!
=ADDRESS(ROW(B1)+MATCH(B52,B1:B50,0)-1,COLUMN(B1),4)

--
AP

"starguy" a écrit dans
le message de news: ...

this formula do not work for any other range. MATCH returns row number
counting from first cell of range, not original row number.

Ardus Petus Wrote:
=ADDRESS(MATCH(B52,B1:B50,0),2,4)




--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=538333
[/color]