Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |