Rating Table

  • 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


    sample_data.xlsx