cell ref
 

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

if there is only one occurance of the number
You can check by =countif(range,value)

you can get the row and column by
=sum(if(range=value,row(range),0))
entered as an array (control-shift-enter)
and
=sum(if(range=value,column(range),0))
also entered as an array


if there is more than one occurance, it gets more complicated
and depends on what you want to do with the information.


"ceemo" wrote:


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

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