| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup return value from 2 columns
Thanks guys
"T. Valko" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup: Return Multiple Columns? | Excel Discussion (Misc queries) | |||
| vlookup to return 2 columns | Excel Discussion (Misc queries) | |||
| vlookup 3 columns all return same | Excel Discussion (Misc queries) | |||
| Can I return multiple columns from a vlookup? | Excel Worksheet Functions | |||
| Vlookup return multiple columns | Excel Worksheet Functions | |||
Hybrid Mode
