Stupid Question of the day. (re: VLOOKUP)

[SuperSean]

Hi, sorry this is probably a lame question.

Is there any way to get VLookup (or any other function/formula) to give me all the info in a row instead of just what matches?

I have VLOOKUP working just fine, I want to display multiple cells however.

Thanks,

 

[Brian from Maui]

SuperSean,

What kind of info?

 

[SuperSean]

Heya,

I have food suppliers costs, product names id # ect in a big big list, needed to pull info from the big list and stick it on a smaller list for other people to see.
I eventually figured it out, though there may have been a quicker way, I did a vlookup for each catagory based on the criteria of the original search.

 

[Asala42]

Hey Sean,

I'm pretty sure you'll need a vlookup per column of data you're pulling in. You may be able to moph a single copy-able formula by automating the column reference in the vlookup.

For example instead of:

=Vlookup(A2,Sheet2!A2:E200,2,false) --where you'd just change the ,2, to ,3, in the next column over)

try:

=Vlookup(A2,Sheet2!A2:E200,Column(Sheet2!A2)+1,false)

The advantage would be that you can copy this Vlookup and pull the correct data.

Tweak where necessary
Adam

 

[SuperSean]

Thanks Adam!

You were correct, this is what I did:

=VLOOKUP(Sheet3!$A10,Sheet1!$A$2:$E$3104,1,FALSE)

I then just draged it down to the other cells I needed to , copied it across ect...


Thanks for your help.