VLOOKUP

[818jaime]

Help
I'm trying to setup a vlookup table
Is it possible to setup my table vertical ( I have my data going up
and down) and the lookup table has the data going accross (horizontal)

Can I still setup a vlookup with my data dragging up and down and the
source where I im pulling is horizontal?? please help.

 

[Don Guillett Excel MVP]

Help
I'm trying to setup a vlookup table
Is it possible to setup my table vertical ( I have my data going up
and down) and the lookup table has the data going accross (horizontal)

Can I still setup a vlookup with my data dragging up and down and the
source where I im pulling is horizontal?? please help.

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

 

[zvkmpw]

Help
I'm trying to setup a vlookup table
Is it possible to setup my table vertical ( I have my data going up
and down) and the lookup table has the data going accross (horizontal)

Can I still setup a vlookup with my data dragging up and down and the
source where I im pulling is horizontal?? please help.

I'm not quite sure about the data setup being described, but maybe
HLOOKUP would help.