Vlookup

[Trainer]

I have the table below - assume we're starting with row 1, col a. I want to
lookup the rate based on Job Type and Type of Time which is in the table
below that, ie Jones's rate who is in Assembly, would be $6.75. The Vlookup
formula: =vlookup(B2,a11:d13,2) works as long as Type of Time is 2 but not if
it's 3 or 4. Can anyone help please.

Employee Job Type Hrs. Worked Type of Time Rate Pay
Jones Assembly 5 2 $-
Smith QC 3 4 $-
Gray Sorter 7.5 3 $-
Kline Assembly 2 2 $-

Job Type 2-Full Time 3-Part Time 4-Overtime
Assembly $6.75 $5.75 $10.75
QC $7.00 $6.00 $11.00
Sorter $5.50 $5.00 $9.00

 

[Stefi]

=INDEX($B$11:$D$13,MATCH(B2,$A$11:$A$13,0),MATCH("*"&D2&"*",$B$10:$D$10,0))

--
Regards!
Stefi



„Trainer†ezt írta: