vlookup reverse// please help

[Guest]

I would like to reference column 1 from the value looked up in column 8.
How???

 

[R.VENKATARAMAN]

try <match> and <index> functions. excel help on these functions will be of
help

 

[Biff]

How about some details???

Index/Match or Offset

Biff

 

[Dave Peterson]

And Debra Dalgleish has some nice instructions (for both =vlookup() and
=index(match()) at:

http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html