5)I would like to know the formula of how to het the demand using the Match/Index.

6)how to use the concretate formula to get the description from the other sheet

7)How to get the price per item and the item inventory after a 5 percent Markup?

18 AutoSave On CIS 2640 Assignment 1_workfile (4) Saved Search File Home Insert Draw Page Layout Formulas Data Review View Automate Developer Help LA Calibri 11 A A == 307 ab Wrap Text General v Paste BIU H A ~ = = = = = Merge & Center $ % 950 00 Conditional Formatting Cell Format as Table Styles Undo Clipboard Font Alignment Number Styles K31 fx A B C D 19 (3) What is the total price of the product entered in the orange cell below? Answer this question using vlookup in E20. 20 Product ID: 529 Total price: $181.50 21 22 Insert Delete Format Cells Angie Gomez Sort & Find & Filter Select Editing AG 0 Comments Share Analyze Data Sensitivity Analysis Sensitivity G H J K L M N 0 P Q R S T U V W X Y Z AA AB 23 (4) You get a #N/A error if you enter a product ID that s not in the lookup table. Use vlookup E24.Print "Value not found" when there is an #NA error. 24 Product ID: 322 Quantity: #SPILL! 25 26 27 (5) What is the demand of the first three items from the 'Inventory' worksheet? Use Match/Index in E28-E30 to answer this question. 28 Product ID: 29 Product ID: 30 Product ID: 10-1 10-10 10-11 Demand: Demand: Demand: 31 32 33 (6) What is the product description of product 10-10? 34 Product: 10-10 35 36 Description: 37 38 39 (7) Show the total price of product 410 after a 5% markup. 40 41 42 Product: Price per item: 43 Value all of the item in inventory: 44 45