Having troubles with two parts to this practice question: they are listed as follows

C.Add a column at the right of Product. Name it Price. Use vLookup function to pull product prices from the sheet Income Statements (B4:D7) and show unit prices for all orders.

D. At the right of Total, add a column called Discount. Use a nested IF function to decide the discounts. The company gives 10% discount on Total to all orders from the West region, and the other regions only enjoy 8% holiday discount in December (Dec).

Order ID Salesperson 2 Nathan 15 Chris 39 David 51 Alex 54 Felicia 57 Nathan 73 Amy 78 Sharon 79 Lauren 80 Jim 84 Sharon 104 Felicia 105 Felicia Product - PriceMonth May Feb A Sep Dec Jan Apr Feb 22 Region Midwest Midwest Midwest Midwest Midwest Midwest Midwest Midwest Midwest Midwest Midwest Midwest Midwest Unit - Total Discount 19 $0.00 $0.00 35 $0.00 $0.00 35 $0.00 27 $0.00 8 $0.00 49 $0.00 9 $0.00 44 $0.00 $0.00 $0.00 50 Son Xan WIU Oct Jul Jan Nov Noy 2016 Income Statement Revenue COGS Revenue Products Unit Sold 6543 6205 6838 6 060 Unit Price Unit Cost $62.00 $48.00 $48.00 $35.00 $46.00 $34.00 $35.00 $27.00 D Total Revenue Total COGS Gross Profit Operating Expenses Salaries Advertising Miscellaneous Total Operating Expenses Earnings Before Taxes Taxes Net Profit