Vlookup backwards

[GarToms]

Hi all,

I'm trying to lookup data in row B and output data in row A. Anyon
know a way to do this cos VLookup only lets me output data in from o
row B.

Cheer

 

[VancitysFinest]

Use a combination of the INDEX & MATCH functions. Its tricky at first
but worth learning.

Or you can just cheat and output the data in some hidden column and
link to that data.

~ Victor Lai

 

[Dave Peterson]

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))