Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup
I have a worksheet I am trying to have the user select the year for the pay
rates and after that I want them to use a Vlookup function. IE-Year:2008 =VLOOKUP(C10,'Equipment & Labor Sheet'!A:W,3,FALSE) I am making a bid form so that a year is first selected based on when the work will be completed. Then the user will select from a drop down both the equipment and type of labor. Once they enter the number of hours per day then it will look up the pay rate accordingly. Ultimately I would like it to calculate based on the type of job (some require hours over 8 to be OT) to look up the specific rates and calculate the cost ie if they worked 10 hours and 2 of those hours were OT. |
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 | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |