referencing cell based on specific data in excel

Posted on

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

Leave a Reply

Your email address will not be published. Required fields are marked *