Can someone please help me with the formula for each column. I think once I get the formula i can use fill handler to get the rest of the answers.

Add formulas in cells highlighted in blue and perform basic lookup to calculate and evaluate data.

1. Lookup unit price, unit shippingand shipping discount

2. Calculate total price total shipping and grand total based on the information retrieved

Tips: use correct range_lookup value (I.e true vs false)

Be careful with reference formats ( ie, absolute, relative, mixed). Im other words make sure reference is correct when using fill handle to automatically generate formulas.