VLOOKUP Question

[Allienne]

Hello!

I've been asking a lot of questions lately, but please bear with me. I am trying to learn as fast as I can.

I have two columns, V & W. What I want to see if I can do is vlookup V5 & vlookup W5 in the same table and combine them together. Example, in Sheet1 Column V says Apple and Column W says Juice. In Sheet2 Next to Apple is says "Succulent Fruit" and Next to Juice it says "Liquid produced by squeezing fruit." What I want is to look at Columns V & W and put it in Column X "Succulent Fruit - Liquid produced by squeezing fruit.".

I tried putting =VLOOKUP(V5,'DESCRIPTION TABLE'!$C$8:$E$20,2,FALSE) & "-" & VLOOKUP(W5,'DESCRIPTION TABLE'!$C$8:$E$20,2,FALSE) in X5 but it only gives me #N/A. Any help would be appreciated.

Any additional information needed, please just let me know.

 

[JoeMo]

#N/A indicates that one or both of your lookup formulas fail to find a match in column 2 of the range 'DESCRIPTION TABLE'!$C$8:$E$20. Perhaps you have a spelling error or some extra spaces or ..., or you have chosen the wrong column.

 

[Allienne]

JoeMo,

Should that formula work? I wasn't sure if I could link the VLOOKUPs that way or not.

 

[JoeMo]

I don't see anything wrong with the formula.

 

[alvisonhunter]

Hello!

I've been asking a lot of questions lately, but please bear with me. I am trying to learn as fast as I can.

I have two columns, V & W. What I want to see if I can do is vlookup V5 & vlookup W5 in the same table and combine them together. Example, in Sheet1 Column V says Apple and Column W says Juice. In Sheet2 Next to Apple is says "Succulent Fruit" and Next to Juice it says "Liquid produced by squeezing fruit." What I want is to look at Columns V & W and put it in Column X "Succulent Fruit - Liquid produced by squeezing fruit.".

I tried putting =VLOOKUP(V5,'DESCRIPTION TABLE'!$C$8:$E$20,2,FALSE) & "-" & VLOOKUP(W5,'DESCRIPTION TABLE'!$C$8:$E$20,2,FALSE) in X5 but it only gives me #N/A. Any help would be appreciated.

Any additional information needed, please just let me know.

Hello Alliene,

I am not totally sure I understood what is it that you are looking for on this but from my understanding, you could try some like this, using the details on Sheet1 and Sheet2 as you described it on this post. Please let me know if this helps!

=CONCATENATE(VLOOKUP(V2,Sheet2!V:Y,2,0)," - ",VLOOKUP(V2,Sheet2!V:Y,4,0))