click cell D13 on the Data sheet and insert a VLOOKUP function that looks up the tutor code, compares it to the data for the package, and returns the description. Copy the function down through cell D22

Base Price Commission $1,699 2.5% $1,749 3.0% $1,799 3.5% $1,849 4.0% $1,899 4.5% Package 10 20 30 40 50 60 70 Tour Description Adventures in Canada Check Out the Czech Republic! Croatian Wonders Live it Up London Parisian Pleasures Roaming Rome Viva Espaa Departure 6/11/2016 6/4/2016 6/11/2016 6/18/2016 6/25/2016 6/11/2016 6/25/2016 Base Cost $1,699.00 $1,799.00 $1,899.00 $1,699.00 $1,749.00 $1,849.00 $1,799.00 European Excursions Agent Sales and Commissions Input Area Taxes and Fees 20% Loan APR 7% Months Per Year 12 Total Payments 3 Agent Name Avery Collins Avery McDonnough Ross Shannon Collins Ross McDonnough Ross Student ID 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 Total for all trips: Average trip cost: Median trip cost: Tour Code 20 30 10 50 60 70 10 40 50 60 Trip Description Departure Date Summary Statistics Total for all trips: Average trip cost: Median trip cost: Lowest cost: Highest cost: Today's date: Base Cost of Total Trip Cost withStudent Taxes PaymentAgent Plan Commission 2016 Total Sales by Agent January - June Avery Collins Kinsley McDonnough Ross Shannon January $ 3,671 $ 1,549 $ 2,996 $ 2,003 $ 4,038 $ 1,172 February $ 2,973 $ 992 $ 6,948 $ 4,190 $ 2,064 $ 866 March $ 4,017 $ 2,267 $ 4,205 $ 3,496 $ 7,015 $ 2,109 $ $ $ $ $ $ April 5,040 3,201 5,523 1,975 6,832 3,385 $ $ $ $ $ $ May 4,963 4,008 6,597 2,936 5,971 4,078 $ $ $ $ $ $ June 5,497 3,798 5,147 3,498 5,497 3,598 Trends Bonus Bonus $ 500