Forum Discussion
Foday655
Mar 25, 2021Copper Contributor
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...
- Mar 25, 2021
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,
HansVogelaar
Mar 25, 2021MVP
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,
Foday655
Mar 25, 2021Copper Contributor
Many thanks Hans, this helps a lot.