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