I have attached the spreadsheet used to answer the following question.

1. In the worksheet named 'VLOOKUP' do the following below the Sporting Goods Inventory List:
   1. Write an 'INDEX' formula to find the value at the intersection of the 4^th row and the 7^th column in the Inventory table.
   2. Write a 'VLOOKUP' formula to find the Reorder Quantity for the Basketball product.
   3. Write a 'VLOOKUP' formula to find the Preferred Supplier for the Baseball product.
   4. Write an 'INDEX'-MATCH formula to find the Preferred Supplier for the Baseball product.

HINT: Before creating the above formulas define the appropriate data arrayamed range for the Inventory table

i Sporting Goods Inventory List for 2020 Item Name Preferred Supplier Tennis racket Sports Supplies, Inc Golf club (driver) GA Sports Distribution Can of tennis balls GA Sports Distribution Basketball Sports Supplies, Inc. Football GA Sports Distribution Baseball bat GA Sports Distribution Baseball We Sell Sports Soccer ball We Sell Sports Baseball glove We Sell Sports Hockey stick Sports Supplies, Inc. Total Inventory Cost Quantity on Hand 200 250 400 150 600 300 475 100 1000 500 Reorder Point | Reorder Quantity 100 150 150 150 250 250 100 200 400 200 200 300 300 80 120 600 600 275 275 300 Cost per Unit $60.00 $80.00 $2.00 $11.25 $12.00 $35.00 S6.00 $15.00 $20.00 $40.00 Sales Price per Unit S150.00 $200.00 $4.00 $25.00 $30.00 $100.00 $15.00 $30.00 S50.00 $90.00 Total Item Cost S12.000.00 $20,000.00 $800.00 $1,687.50 $7,200.00 $10.500.00 $2,850.00 $1,500.00 $20,000.00 $20,000.00 S96.537.50