VLOOKUP - Getting a reference

[Rodrigo]

I am currently using VLOOKUP the way it was meant to be
used (to return the value "Y" from a specified column and
the same row of the value "X" on the first column, from a
specified cell range "TABLE.")

What I need to do is to get the ADDRESS of the value that
VLOOKUP is returning, not the value itself.

Can anyone please help ?? Cheers !

 

[GB]

Use the Match function to find the row. The column you already know.

Geoff

 

[Peo Sjoblom]

Assume your vlookup table is called MyTable

=CELL("address",INDEX(MyTable,MATCH(A1,INDEX(MyTable,,1),0),2))

will return the address, a vlookup that retrieve the value would look like

=VLOOKUP(A1,MyTable,2,FALSE)