vlookup return value from 2 columns
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)
--
Biff
Microsoft Excel MVP
"Hugh self taught" wrote in
message ...
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
|