Hi, i have the following carriage cost table on a sheet called "Carriage Matrix"
The headings of each column B:E is the different type of deliveries e.g. Pallet standard, pallet next day etc.
The prices for these depends on the zones as you can see in column A.
I then have my main data sheet called "MainData". I want to use index/match to fill in Column N "Carriage Cost" depending on what delivery type is chosen in Column G and which zone is chosen in column N
Hope that is clear, I think index/match is the best way of going about this but i could be wrong. I want Column N to automatically be filled based on delivery type in Column G and zone in column M by referencing the carriage table on the sheet "Carriage Matrix" shown above
The headings of each column B:E is the different type of deliveries e.g. Pallet standard, pallet next day etc.
The prices for these depends on the zones as you can see in column A.
I then have my main data sheet called "MainData". I want to use index/match to fill in Column N "Carriage Cost" depending on what delivery type is chosen in Column G and which zone is chosen in column N
Hope that is clear, I think index/match is the best way of going about this but i could be wrong. I want Column N to automatically be filled based on delivery type in Column G and zone in column M by referencing the carriage table on the sheet "Carriage Matrix" shown above
Last edited: