Cell reference of a lookup

I would like a vlookup to return a cell reference instead of the value in the cell. cant seem to find a formula to work.

Thanks!

Welcome to the board.

You may have to modify this for your range, but it should give you the results you are looking for. I have put in my example a range from A1:A10 with the word "Test" in A4. Then, in B1 I put this formula to return the cell address.

=ADDRESS(ROW(INDEX(A1:A10,MATCH("Test",A1:A7))),1)

The INDEX/MATCH works much like the VLOOKUP. Hope that helps.

Thanks for that - works fine!!