INDEX Sheet2BBMATCH A1914Sheet2AA0 to. Without concatenating values in a helper column or in the formula itself theres no way to supply more than one criteria. Below is a video that explains how to use the MATCH function along with the match type argument To summarize and put it in simple words.
Below you will find a real-life example and the detailed explanation of the logic.
Once MATCH runs the formula simplifies to. INDEX needs the cell position row and column number and gives the cell value. INDEX Sheet2BBMATCH A1914Sheet2AA0 to. To evaluate multiple criteria we use the multiplication operation that works as the AND operator in array formulas.