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

[James]

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

 

[Frank Kabel]

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

 

[Harlan Grove]

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

Maybe

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

 

[James]

thank you!

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