Question: 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

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

provided. (Function goes in cell I3 of the Client Transactions worksheet) 12

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

In cell E5, use the SUBTOTAL function to calculate the total spent for the records visible in the filtered 11 data. Format as Accounting with 0 decimal places. Import the tab delimited text file,...

12 13 Import the tab delimited text file, ex02 TransactionData.txt, into the Client Transactions worksheet, starting in cell A2. Apply the Table Style Light 14 to the range A2:K58, removing the...

Grader - Instructions Excel 2019 Project Exp19_Excel_Ch07_HOEAssessment Employees Project Description: You work for a clothing distributor that has locations in lowa, Minnesota, and Wisconsin. You...

Hey guys! I'm having a little trouble with formulas for these assignment, could any one help me with questions 5, 9, 10, 11, 13, 14, 16, 17, 18, 19. Any help would be super helpful! Thank you! Step...

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

Project Description: Tropical Travel Agency has hired a consulting firm to audit some of its existing business processes to ensure that the business is running efficiently and effectively. You have...

Could you provide me with the necessary journal entries for each event from pages 9,10,11,12, and 13. while using the accounts listed on page 8. (Some events may not need journal entries) (Some...

June 1: Byte of Accounting, Inc. issued 2,580 shares of its common stock to Jeremy after $30,160 in cash and computer equipment with a fair market value of $44,660 were received. June 1: Byte of...

Sales Revenue $230,000 Sales Returns and Allowances = $15,000 %3D %3! Cost of Goods Sold = $150,000 %3D Operating Expenses Income Tax Expense = $2,000 = $42,000 %3D %3D Using the information...

A corporate employee is deemed to be an insider, and buys shares of company stock on May 1 , 2 0 0 8 . He leaves his employment on June 1 , 2 0 0 8 . When can he sell his stock without violating SEC...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

describe the skills shortages encountered by employers, their causes and possible solutions

2. Outline the major stages of the human resource planning process, and comment on the key considerations at each stage.

4. Explain what is meant by the terms skills shortages and skills gaps. Why do they arise and what can employers do about them?