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
|