Open exploring _ ecap _ grader _ h1 _ Trips. xlsx and save the workbook as 00a1Trips _ LastFirst.
Make sure the Lookup Tables sheet is active.
2 Assign the range name rates to the base price and
2.000 commission range.
Assign the name range tours to the data for the package, tour description, departure, and base cost.
3 Click cell D13 on the Data sheet 4.000
Insert a VLOOKUP function that looks up the tour code, compares it to the tours table, and returns the description.
Copy the function down through cell D22.
4 Click cell E13 4.000