Excel Index Match Function Case Study 2
Ken Atigari shows how to dynamically use Microsoft Excel index and match function together . The index function provides the array that the Excel syntax will refer to, while the Match function provides the row and column numbers that will determine the exact cells in the array that will be pulled by the index function.
The case study under consideration is for a "themed review" project in order to assess the quality of data hosted in an Excel database.
In addition to Excel Index and Match functions, other Excel functions used include Data validation, Vlookup, Hlookup, Concatenate, Conditional formatting.