|
Vlookup
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 -- Trainer |
Vlookup
=INDEX($B$11:$D$13,MATCH(B2,$A$11:$A$13,0),MATCH(" *"&D2&"*",$B$10:$D$10,0))
-- Regards! Stefi €˛Trainer€¯ ezt Ć*rta: 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 -- Trainer |
| All times are GMT +1. The time now is 07:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com