Enjay,

You can use the Vlookup function to solve this problem - it is a bit tricky to explain on the forum so if you want to send me an email at the tipping comp email address I can email you a sample spreadsheet to show you how it works.

Regards,
Becareful