Forum Discussion

Foday655's avatar
Foday655
Copper Contributor
Mar 25, 2021
Solved

Freight Cost Calc. based on Transport and Toll Cost with some criteria

Excel 2016, OS Windows Hello all, I am trying to calc. the Total Freight from two different sheet with different data.   Transport data sheet - contains the item type, zip-codes, weights and pri...
  • HansVogelaar's avatar
    Mar 25, 2021

    Foday655 

    You switched the row_number and column_number arguments of all INDEX functions.

    And most of your numeric data were actually text values, making it difficult to work with them.

    See the attached version; I have corrected all the errors I could find, but please check carefully,

Resources