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

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