cell ref

[ceemo]

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

 

[Guest]

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.

 

[Dave R.]

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))