Mar 01 2023 08:25 PM - edited Mar 01 2023 08:26 PM
I am trying to create a calculator that can link pricing from one sheet to another.
I am now stuck & have tried many different formulas but cannot get it to work.
Once you have added in a Postcode, Column L auto populates with the "Rate Zone"
When you select the Service (Which text links to "TNT Rates" Sheet - Row 9 or 15)
I would like Column P to add in the correct pricing per "Rate" from row 9 or 15 depending on the selection.
Can anyone provide any insight?
I don't know if it's the formulas I have tried, the way my data is set out of if it just isn't possible.
I have a spreadsheet I can send through!
"TNT Sheet"
"SHIPPING CALCULATOR" Sheet
Mar 01 2023 10:33 PM
Mar 07 2023 12:47 PM
Mar 07 2023 12:49 PM
@igorotXThank you so much for the response! I have attached the file.
I am unsure if this is possible to do or if my layout needs to be modified slightly to achieve this?
- Row 9 is for if Overnight Service is selected
It then needs to refer to column B-K to see which "Rate" to drop in for pricing
- Row 15 is for if Road Service is selected
It then needs to refer to column B-K to see which "Rate" to drop in for pricing
Mar 10 2023 09:35 PM
Try this in P7...
=IFERROR(INDEX('TNT Rates'!$A$5:$K$16,MATCH(D7,'TNT Rates'!$A$5:$A$16,0),MATCH(L7,'TNT Rates'!$A$5:$K$5,0)),"")