Normally an INDEX MATCH formula is configured with MATCH set to look through a one-column range and provide a match based on given criteria. MATCH function Now we will make a formula using the above functions. The MATCH formula is basically the reverse of the INDEX formula.
VLOOKUP is a much simpler formula.
Without concatenating values in a helper column or in the formula itself theres no way to supply more than one criteria. MATCH function returns the index of the first appearance of the value in an array single dimension array. And then INDEX use that number to figure out the position of the cell from the value column. Working one step at a time lets leave the column hardcoded as 2 and make the row number dynamic.