Trip ID	3002	3003	3009	3010	3050	3107	3142	3179	3190	3204	3222	3395	3488	3503	3515	3529	3611	3628	3670	3675
River	Arkansas River (Brown's Canyon)	Arkansas River (Parkdale)	Arkansas River (Royal Gorge)	Colorado River (Westwater Canyon)	Colorado River (Grand Canyon)	Arkansas River (Brown's Canyon)	Colorado River (Little Gore Canyon)	Arkansas River (Royal Gorge)	Arkansas River (The Numbers)	Arkansas River (The Narrows)	Colorado River (Little Gore Canyon)	Arkansas River (The Narrows)	Arkansas River (Brown's Canyon/Royal Gorge)	Colorado River (Glenwood Canyon)	Colorado River (Little Gore Canyon)	South Platte River	Clear Creek River	Clear Creek River	South Platte River	Colorado River (Grand Canyon)
# of Person	8	10	12	17	4	22	20	5	18	9	23	25	7	18	25	10	9	20	18	3
TripDays	0.5	0.5	0.5	2	5	1	1	1	1	0.5	2	1	2	1	3	0.5	0.5	1	1	2.5
Fee/Person	$45.00	$40.00	$45.00	$180.00	$125.00	$75.00	$85.00	$85.00	$70.00	$85.00	$225.00	$145.00	$199.00	$80.00	$360.00	$35.00	$45.00	$95.00	$75.00	$215.00
Colorado Trip Lookup Table
Enter a Trip ID
River
# of Person
TripDays
Trip Fee
Discount
Total

On Trip Fee Sheet: Using hLookup to set up only one Lookup table. After you finish the following processes, when you enter a trip ID, the rest of information filled in the table automatically:

Using Trip ID to lookup each trip information.

Calculate field Trip Fee that times Fee and Person.

Use the If function to reduce TripFee by 10% if the people is greater than or equal to ten (10).

Calculate Total trip fee.