If C5 is less than 2, then table1 is returned as the value if true.
If C4 is greater than 2, table2 is returned as the value if false.
VLOOKUP with 2 lookup tables
To use VLOOKUP with a variable table array, you can use the IF function inside VLOOKUP to control which table is used. In the example shown the formula in cell E4 is: =VLOOKUP(D5,IF(C4
