Please see attached spreadsheet.
I have generated a spreadsheet which uses 'Index' and 'Match' to come up with the cost of postage if the item being posted is of a certain value and of a certain weight.
I have another spreadsheet which calculates a value of an item before posting - how do I get the attached spreadsheet to calculate the postage if A8 = £49.95 and fell into the weight category 2 - 5kg.
I have tried using 'Sumproduct' for the value, but I don't know how to integrate it all together.
Bookmarks