Return cell address

[Dan]

Is there a formula or function that will return the cell
address? Example: using cell range B1..B10 in which one
cell will have an input value of 1. If cell B2 has a value
you 1, is there a formula that will look at all cells in
the range and return "B2" indicating that B@ is the cell
w/the value? Thanks.

 

[JulieD]

Hi Dan

=CELL("address",INDEX(B1:B10,MATCH(1,B1:B10,0)))

Cheers
JulieD

 

[Bernard Liengme]

No better that Julie's but this also works: =ADDRESS(MATCH(1,B1:B10,0),2)