F5 =INDEX(14:19, MATCH(428,14:19,0),2) O TTUUUCE In A B E F G J K L M N 1 LOOKUP Function 2 (1) What is the color of product 428? What about its unit price? (Use the table on right to answer this question) 3 VLookup version: Color: red Unit Price: 4.4 4 Color Unit Pric Quantity 5 Match-Index version: #N/A 390 orange $4.40 45 6 683 yellow $6.70 37 7 (2) Is item 10-16 made in-house? Use data from the 'Inventory' worksheet to answer this que 428 red $4.40 115 8 Lookup version: Buy or Make: 999 blue $8.30 17 9 547 green $6.70 48 10 Match-Index version: 11 12 (3) What is the total price of the product entered in the orange cell belov? Answer this question using vlookup in E13. 13 Product ID: 547 Total price: $0.00 14 15 (4) You get a #N/A error if you enter a product ID that is not in the lookup table. Use vlookup in E16. Print -Value not found when there is an INA error. 16 Product ID: 320 Quantity: 17 18 (5) What is the demand of the first three items from the 'Inventory' worksheet? Use Match!Index in E19-E21 to answer this question. 19 Product ID: 10-1 Demand: