Hi all,

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

Cheers

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

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()))

GarToms wrote:

Hi all,

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

Cheers

--
GarToms

--

Dave Peterson