How can i find the cell reference of a number im searching for?

James · Mar 29, 2004

for example:
how can i return "B6" if b6 = a specic value?

Frank Kabel · Mar 29, 2004

Hi James
not quite sure but maybe
=IF(B6=value,"B6","")

Harlan Grove · Mar 29, 2004

for example:
how can i return "B6" if b6 = a specic value?

Maybe

=SUBSTITUTE(CELL("Address",INDEX(SomeRange,MATCH(SpecificValue,SomeRange,0))),
"$","")

James · Mar 29, 2004

thank you!

Harlan Grove said:
...
=SUBSTITUTE(CELL("Address",INDEX(SomeRange,MATCH(SpecificValue,SomeRange,0))
),
"$","")