Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to match cartage rates to my dockets
I contract to Boral and they pay me for each load based on distance travelled
and amount carried. They provide me with a rate scale. How can I enter this scale into excel then each month just enter my docket details to check they have paid me the correct amount? |
#2
|
|||
|
|||
I want to match cartage rates to my dockets
Lainey Wrote: I contract to Boral and they pay me for each load based on distance travelled and amount carried. They provide me with a rate scale. How can I enter this scale into excel then each month just enter my docket details to check they have paid me the correct amount? Hi Lainey Enter the rate scale into a separate worksheet and use as a lookup table Use one of the LOOKUP, VLOOKUP or HLOOKUP functions on the sheet with the docket details to return the value from the lookup table that corresponds with the docket details Would really need more details of the data etc to be more specific -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=479679 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |