INDEX/MATCH

The INDEX function in Excel is a powerful lookup function that returns a value at any determined position in an array. The function can return individual values or entire rows and columns. The INDEX function is typically used in combination with the MATCH function, where the MATCH function sends a position to the INDEX function.