Index match or something else?

[Odinson83]

Hi, I need a formula to calculate values based on a table (2 axes). I have quantity along the top and delivery location on the left, I need to know if 7 pallets were delivered to 380 to multiply the value in the table by the quantity (i.e: 53 x 7). the only caveat is if the quantity is more than 14 then to return the flat rate (full trailer load). I've attached the table, any help would be massively appreciated. I thought to use index/match within an If statement but this seems very complex.

[Odinson83]

Just managed to attach, I think

[FlameRetired]

In the attached find this formula in column T.

Please Login or Register  to view this content.

[FlameRetired]

Actually this formula is more robust. It matches "full trailer" rather than the constant "16".

Please Login or Register  to view this content.

[FDibbins]

Odinson83 welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )