Do #13, Having trouble making a VLOOKUP function for the sheets provided. (Function goes in cell I3 of the Client Transactions worksheet)

12 the connection to the text file. On the Client Transactions worksheet, in cell 13, use the VLOOKUP function to retrieve the per ticket cost for each transaction based on the trip city from the data on the Travel Packages worksheet multiplied by the number of guests. Format as Accounting with 2 decimals. 6.000 13 in cell J3, use a VLOOKUP function to determine the discount earned based on the cost of trip