The formula in the helper column (here: cell B4) is =C4&D4&E4 . You apply a "normal" INDEX/MATCH formula with the only difference that you search for the combination of criteria within the MATCH part of the formula. The formula (here in cell J10) is =INDEX(F:F,MATCH(J3&J4&J5,B:B,0)) . Teams. Q&A for work. Connect and share knowledge within a single location that is structured and easy to search. Learn more about Teams So, the formula changes from: =INDEX(D:D,MATCH(G2,A:A,0)) To: =INDEX(D:D,MATCH(1,A:A,0)) The "theory" behind this is not as simple as changing the lookup value. Since you're changing the formula from a normal one to an array formula, the structure of the formula changes a bit as well. I am experimenting with excel's functions. Say I have the following example values Column A1 - "Andrew" B1 - "Morton" B2 - "Andrew" A2 - "Morton" A3 - "2" Why is my formula not printing the outp To do this, right-click on cell A13, go to view more cell actions, and click on Data Validation. Step 2: Once in the Data validation menu, select List from a range, and select A2:A10. Once you have done this for cell A13, do the same for cell B13. Step 3: Use the =INDEX (reference,MATCH (1, (criteria1)* (criteria2)…,0)) to index match on FbmBb.

formula index match multiple criteria