Use a formula to match different product criteria to a pricing corridor

Hi!

I wonder if somebody can help me on the following. I ploughed through the forum looking for an answer, but unfortunately haven't found anything that works.

In the company I work for we work with corridor pricing. This means that each individual product needs to be matched to the correct corridor based on the segment and size in order to calculate the correct price for it. How can I do this using a formula?

As an example: These are the products I want to match:
Image 1.JPG

And this is part of the source data where I want to retreive the corridor description from:
Image 2.JPG

I also created a quick excel if you want to try and work the data:
Match Corridor Description.xlsx

I'm curious what you see as the best solution.

Your help is much appreciated.

Regards,
Peter

It is always helpful to include expected results so that we will have a target to shoot at so to speak. However I feel as if the following formula will work:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.