VLOOKUP Function to return values in multipal Columns
Just expand the Table definition part from:
=VLOOKUP(C5,Sheet1!B$1:C$16,2,FALSE)
to:
=VLOOKUP(C5,Sheet1!B$1:Z$16,2,FALSE) draw from column C
=VLOOKUP(C5,Sheet1!B$1:Z$16,3,FALSE) draw from column D
=VLOOKUP(C5,Sheet1!B$1:Z$16,4,FALSE) draw from column E
=VLOOKUP(C5,Sheet1!B$1:Z$16,5,FALSE) draw from column F
=VLOOKUP(C5,Sheet1!B$1:Z$16,6,FALSE) draw from column G
etc.
--
Gary''s Student - gsnu200838
"KP" wrote:
I'm using the VLOOKUP function to look up value in another sheet and return
the corresponding value, My problem is It works for the first column but the
how do I get the next 4 columns
Sheet 1 has the date that needs to be looked up and once the Employee name
is found then return the corresponding values in Column D,E,F
Sheet 1
C D E F
Employees Volume Hours VPH
ABC 100 10 3.3
Result Sheet
Formula being used
=VLOOKUP(C5,Sheet1!B$1:C$16,2,FALSE) to Match the name and get the value in
column D in Sheet 1
=VLOOKUP(D5,Sheet1!C$1:D$16,2,FALSE) to get the value of Column E in Sheet 1
for the above match.
Hope I explained this correctly.
--
Thanks
KP
|