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 .