vlookup return value from 2 columns

  • Thread starter Thread starter Hugh self taught
  • Start date Start date
H

Hugh self taught

Hi All,

Vlookup in it's basic usage is no problem for me but now I need to lookup a
matching value in column 2 & return the values of columns 3 & 4. Preferably
in the format of xxxxxxx & yyyyyyyy since columns 3 & 4 are names.

If you could help with any method that is simple & works would be great.

Cheers
Hugh
 
Just concatenate 2 lookups together. Something like this (all on one line):

=VLOOKUP(A10,B1:D5,2,0)&" & "
&VLOOKUP(A10,B1:D5,3,0)

Or, you can add another column to your table with the names already
concatenated:

=C1&" & "D1

Then do the lookup on this new column:

=VLOOKUP(A10,B1:E5,4,0)
 
Hi All,

Vlookup in it's basic usage is no problem for me but now I need to lookupa
matching value in column 2 & return the values of columns 3 & 4. Preferably
in the format of xxxxxxx & yyyyyyyy since columns 3 & 4 are names.

If you could help with any method that is simple & works would be great.

Cheers
Hugh
Click to expand...

Give this try. Change cells in this formula to match your needs.

=VLOOKUP(A1,A7:C9,2)&" "&VLOOKUP(A1,A7:C9,3)
 
Hi,
try
You have the value to lookup in cell D2, values in column A from row 1 to 4,
and the information to put together in rows B and C

=IF(SUMPRODUCT(--(D2=A1:A4)),B1:B4&C1:C4)

change range to fit your needs
 
Thanks guys

T. Valko said:
Just concatenate 2 lookups together. Something like this (all on one line):

=VLOOKUP(A10,B1:D5,2,0)&" & "
&VLOOKUP(A10,B1:D5,3,0)

Or, you can add another column to your table with the names already
concatenated:

=C1&" & "D1

Then do the lookup on this new column:

=VLOOKUP(A10,B1:E5,4,0)
Click to expand...
 
Back
Top