How to Use VLOOKUP- Multiple Column Index using Array Formula

The VLOOKUP function does not handle multiple criteria natively. However, if you have control over source data, you can use a helper column to join multiple fields together, and use these fields like multiple criteria inside VLOOKUP. VLOOKUP with a variable table array, you can use the IF function inside VLOOKUP to control which table is used. This formula uses the number of years a salesperson has been with a company to determine which commission rate table to use. In this video you will learn How to do VLOOKUP Function- Multiple Column Index using Array Formula in Excel.

[bgrg]

doesn't work for me. what am i doing wrong? once i've typed the formula, i hit ctrl+shift+enter and the curly brackets appear but my formula still only returns one value, reciprocrating the first col_index