Please show your steps and the formula. i am using office 360

AS2 A B n 1 B D Small Medium Large 10 12 15 30 35 40 25 30 35 2 Sweater 3 Jacket 4 Pants 5 6 Size 7 Medium Price Item Pants 8 9 Required 1: Using a single reference formula, retrieve the price for the item described in Cells AZ & B7. 10 11 A B D E F G H Cost $884 Stock Item Stock ID 1 2 Stock ID 3 TEL458 4 LAP5987 5 TAB698 6 MON632 7 DRO844 8 Stock Item Price Television $8,959 Laptop $7,840 Tablet $7,507 Monitor $6,690 Drone $5,802 $976 $689 $588 $555 covo O Required: 1. In Cell G4, create a dropdown list populated with the Stock Item names (e.g., Television, Laptop, Tablet, Monitor, and Drone). 9 2. In cell H4, return the Stock ID for Tablet. Create a reference formula that will change as the stock item is changed in cell G4. 10