Hello i am trying to create a rating simulation spreadsheet for shipping and need some help.
When a service type - SG is used i need it to then go to worksheet SG where the rates are
then on worksheet SG - I need it to select the right Zone (Column F) and right weight (Column D) to return a base rate for a package.
the rest of the variables i have been able to accomplish as they are simple formulas.
The goal is for a client to be able to copy and paste there data in the shipment detail area and for it to auto populate all of the rates/surcharges for a total