Take a look at the VLOOKUP function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jet Boat Ron" wrote in
message
...
I own a tour boat biz and pay the pilots by the trip.
1 trip =$30.00
2 trips=$60.00
3 trips=$115.00
4 trips=$127.50
5 trips=$150.00

How do I do a fomula for this?

column 1 column 2 column 3
date trips pay

1 jun 3 $115.00