Excel copy and paste

Pricing Information for Tennis Balls $$ Unit Pricing

Tennis Balls Shipping Costs Qty $$/$each Cost$/$Unit Shipping Method Shipping Discount $0$$$2\mathrm{.}45$$$0\mathrm{.}25$ Truck Total Price: $$$$0$$$300$$$1,00060$$$2\mathrm{.}27$$$0\mathrm{.}20$ Rail Shipping Discount$0\%10\%15\%120$$$2\mathrm{.}12$$$0\mathrm{.}15$ Ship $240$$$2\mathrm{.}00$$$-$ Customer Order# Cust ID Shipping Quantity Unit

Price Total Price Unit Shipping Total Shipping Shipping Discount Grand Total $1$ A$0243$ Rail $2402$ MH$394$ Rail $303$ R$903$ Ship $1604$ X$271$ Truck $2155$ N$271$ Truck $906$ CD$031$ Customer $15$ Add formulas in cells highlighted in blue, and perform basic lookups to calculate & evaluate data $$ Requirements: $1.$ Lookup "Unit Price", "Unit Shipping" &$"$ Shipping Discount".$2.$ Calculate "Total Price", "Total Shipping" & "Grand Total" based on the information retrieved $$ Tips: $1.$ Use correct range$\_$lookup value $($i$.$e$.$ TRUE vs$.$ FALSE$)2.$ 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. $$