Question
Help with Hlookup table On Trip Fee Sheet: Using hLookup to set up only one Lookup table. After you finish the following processes, when you
Help with Hlookup table
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.
| 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 | ||||||||||||||||||||
|
| ||||||||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Systems Design Implementation And Management
Authors: Carlos Coronel, Steven Morris
14th Edition
978-0357673034
