VLOOKUP - Getting a reference

  • Thread starter Thread starter Rodrigo
  • Start date Start date
R

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 !
 
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)
 
Back
Top