Find Cell Address

[timber]

hi, does anyone knows the formula to find the cell location of a numbe
from a range of cells? for example, 10 is in F2. i need to find th
cell location of 10 from A1:E10. Thank You

 

[Frank Kabel]

Hi
some formulas (all array formulas entered with
CTRL+SHIFT+ENTER):
1. Row number (of the first element):
=MIN(IF(A1:E10=10,ROW(A1:E10)))

2. Column Number
=MIN(IF(A1:E10=10,COLUMN(A1:E10)))

3. Cell address
=ADDRESS(MIN(IF(A1:E10=10,ROW(A1:E10))),MIN(IF
(A1:E10=10,COLUMN(A1:E10))))

 

[timber]

hi Frank, thanks. i edit value to be found in your formulas and it work
to find the location of the value correctly with the condition the valu
must exist only once within A1:E10. thank you. bye