Using two tables to arrive at the correct number

Greetings everyone! i hope that someone can help me with this problem.

here is my problem:

here is my problem:

there are two tables listed above. If cell I1 is less than 25 and cell L1 is less than 13 then the index and match should point to table A1:F10
however, if the cell is 26 or greater and L1 is greater than 13, then the index and match should point to table G4:L10

on widths 24 and less, the formula that is currently in cell A1 seems to be working properly. I cannot get the formula to pick up the second table when the width is >24

I have provided data validation in cells I1,J1 and L1 (cell color is dark green). These are the only cells that will\should be manually changed to affect the formula result


please help!

thanks in advance for your assistance.

EXAMPLES TO TRY:
if cell I1 is 24 and J1 is 30 and L1 is 10 - the formula should point to table 1 and give a result as 385.00
If cell I1 is 26 and J1 is 30 and L1 is 10 - the formula should point to table 2 and give the result as 530.00


I have attached a workbook for clarification

Please Login or Register  to view this content.

Sorry for my miscommunication.

it should have read, table 2 if cell I1 is >=26 AND L1<13.

sorry for the mix-up.

Originally Posted by FDibbins

Try this...
=INDEX($B$5:$L$10,MATCH($M$1,$A$5:$A$10,0),MATCH(J1,$B$4:$F$4,0)+IF(I1=26,6,0))

This formula works beautifully! Could you please tell me what the +IF(I1=26,6,0)) represents?

excellent solution! works great. thanks for all your help.

thanks for the excellent answer! could you however, please explain what the 1,2 represents at the end of the formula? i am trying to wrap my head around this. i cannot figure out how the formula knows which table to use.

thanks for your trouble in advance!