vlookup for multiple columns

J

JR

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
 
D

Dave Peterson

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.
 
Top