What is INDEX MATCH in Excel?
The INDEX MATCH Formula is the combination of two functions in Excel: INDEX and MATCH.
=INDEX() returns the value of a cell in a table based on the column and row number.
=MATCH() returns the position of a cell in a row or column.
#indexMatchFunction #indexMatchFormula