Insert a lookup function that looks up the tour code, compares it to the tours table, and returns the departure date.
Copy the function down through cell E22.
5 Click cell F13 4.000
Insert a lookup function that looks up the tour code, compares it to the tours table, and returns the base cost of the trip.
Copy the function down through cell F22.
6 Click cell G13 4.000
Insert a formula that adds taxes and fees to the base cost of the trip( in cell F13) by using the percentage value in the input area. Use a mixed reference to the cell containing 20 % in the input area above the data.
Copy the formula down through cell G22.