Write a function in cell I8 that will return sales amount for any specified product type (cell I6) in any specified month (cell I5). Use cells I5 and I6 for the month and product names, respectively. Hint: You need to use VLOOKUP and IF together.

29% O Sun 7:25 PM a 5 Comm Excel File Edit View Insert Format Tools Data Window Help o. AutoSave OFF HESU Ass 1 Home Insert Draw Page Layout Formulas Data Review View 18. Connections M 1 TA Y Get External Refresh Stocks Geography Z Sort Filter Data All Edit Links H13 x fx 3 Share B Group ele Ungroup Clear Reapply Advanced Properties GIAE Text to Columns F Se What If Analysis Subtotal A B C D E F G A Sales Lookup Month Product Month Product Sales 3 Month BC D 4 January $7,792 $4,309 $826 $2,552 $4,278 5 February $7,348 $9,430 $11,512 $13,594 $15,676 6 March $7,748 $3,434 $8,856 $5,519 $2,182 7 April $7,784 $8,583 $9,382 $10,181 $10,980 8 May $8,475 $2,390 $4,545 $3,553 $2,561 9 June $8,576 $2,829 $6,664 $5,532 $4,400 10 July $8,697 $5,999 $3,301 $603 $2,095 11 August $8,886 $10,003 $11,120 $12,237 $13,354 12 September $9,403 $10,056 $10,709 $11,362 $12,015 13 October $8,695 $8,884 $9,073 $9,262 $9,451 14 November $5,794 $9,958 $14,122 $18,286 $22,450 15 December $8,904 $3,984 $5,554 $6,654 $7,754 16 17 Write a function in coll 10 that will return calor amount for any enacified product tunalcoll 16 in 3-Pivot Table-40 points 4-Heat Map-Sparklines-10 points 5-Excel functions-15 points + 6- VLOOKUP-15 points 2 Sheet4 - Ready + 13