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
![]()
Bookmarks