Here's one way assuming your lookup range is f9:f13 and you are looking up
the value 222. adjust the ROW() and COLUMN() as your range (f9:f13) changes
to other columns or start rows.

=ADDRESS(MATCH(222,F9:F13,0)+ROW(F9)-1,COLUMN(F9))



"ceemo" wrote in
message ...

hi say i have in column a a list of numbers and i want to find the cell
ref (column and row) of a specific number, can i do this?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=383496