QUESTION :
I want to get the cell address (column number and Row number) based on the data it has.
Example: Cell A1 has value 8 and column B has number 1 to 100 in random order (no value repeating twice). I want to know which cell in column B has the same value as cell A1 and enter that value in cell A2.
ANSWER :
=match(a1,b:b,0) will return row of the match from cell A1