Formula Help - Like V Lookup but Multiple Criteria to Match

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.

See "Shipping Calculator" Image
Column "P"

Once you have added in a Postcode, Column L auto populates with the "Rate Zone"

Now, 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" to match column L, 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.

Thanks so much - This seems to work!
The only issue is it is bringing the pricing over from 1 column over to the left of the actual price needed.
Do you have any more insight? I have had a look over the formula you have kindly provided & cannot seem to work this one out.

E.g On the document you have attached, See Column P (Calculator Sheet) is bringing over price $12.16 from Column B (TNT Sheet) which should actually be pricing from column C as per "Rate 2"