Need help with question 2, 4, 5 and 6. thank you in advance.

M N o Q R s green A B B D E F G H I K L 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.40 4 4 Product ID Color Unit Price Quantity 5 Match-Index version: red $ 4.40 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 question. 428 red $4.40 115 8 Lookup version: Buy or Make: Make 999 blue $8.30 17 9 547 $6.70 48 10 Match-Index version: 11 12 (3) What is the total price of the product entered in the orange cell below? Answer this question using vlookup in E13. 13 Product ID: 547 Total price: $321.60 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 #NA 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: :