There seems to be some mismatch here. you stated If cell I1 is 26 and J1 is 30 and L1 is 10 and the formula should point to table 2 and give the result as 530.00
But you also mention you wanted to pick up the data from table 2 if cell I1 is >=26 AND L1>13. so how can it work since L1 is 10? =\
Bookmarks