K

#### KP

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$16,2,FALSE) to get the value of Column E in Sheet 1

for the above match.

Hope I explained this correctly.