Simply put INDEX takes a cell range and returns a cell within that range based on a count provided by the user. The problem is that is apparently matter which row I run the INDEX-formula in. VLOOKUP and MATCH formula for 2-way lookup.
Simply put INDEX takes a cell range and returns a cell within that range based on a count provided by the user.
MATCH This function helps to locate the position of a lookup value in a row column or table. We can just replace that with the MATCH formula we wrote. INDEX range row_or_column That may sound a bit complicated but its actually easy once you see it in action. Without concatenating values in a helper column or in the formula itself theres no way to supply more than one criteria.