IF , Vlookup function help

i have a certain reimbursement rate for certain zip codes.  There are 2 levels, rural and super rural.  Each has its own rate of reimbursement.  For instance, Rural is 284.75, while super rural is 349.10-for one particular service (A0426)

 

Part of the problem is that there are different services.  (A0426, A0427, A0428, A0429, A0433 and A0434).  Each pays a different rate.

There is also mileage which is paid per mile (A0425).

Im using Excel 2007

We want to type in a zip code, service and mileage and have a formula that figures out how much to bill.  Where do i start??? thanks

By: scott

Leave a Reply

Your email address will not be published. Required fields are marked *