Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup for multiple columns
Hello,
How would I go about using a vlookup to bring in data from three columns? For example: column A €“ Start column B €“ Middle column C €“ End each row of course has the date, but I want the vlookup to return all three columns so the vlookup cell looks like this: Start Middle End Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup for multiple columns
I think the simplest way would be to use 3 different =vlookup() formulas.
=vlookup(a1,sheet2!a:d,2,false) =vlookup(a1,sheet2!a:d,3,false) =vlookup(a1,sheet2!a:d,4,false) Column A will contain your key value to match. JR wrote: Hello, How would I go about using a vlookup to bring in data from three columns? For example: column A €“ Start column B €“ Middle column C €“ End each row of course has the date, but I want the vlookup to return all three columns so the vlookup cell looks like this: Start Middle End Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding three consecutive columns | Excel Worksheet Functions | |||
Using VLOOKUP to draw data from two columns | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
vlookup for multiple columns | Excel Worksheet Functions | |||
VLOOKUP won't work | Excel Worksheet Functions |