A

B

B

$1$

Add formulas in cells highlighted in blue, and perform basic lookups to calculate & evaluate data

Requirements: quad $1.$ Lookup "Unit Price", "Unit Shipping" &$"$ Shipping Discount".

Lookup "Unit Price", "Unit Shipping" & "Shipping Discount". Calculate "Total Price", "Total Shipping" & "Grand Total" based on the information retrieved

Tips:

Use correct range$\_$lookup value $($i$.$e$.$ TRUE vs$.$ FALSE$)$

Be careful with the reference formats $($i$.$e$.$ absolute$,$ relative, or mixed$).$ In other words, make sure the reference is correct when using fill handler to automatically generate formulas. submitted this question before but for some reason unit shipping and the last columns come up wrong please help