To retrieve thevalueof a cell at a certain position, use theINDEX function.
MATCH supports approximate and exact matching, andwildcards(* ?)
you’re free to use INDEX to retrieve individual values, or entire rows and columns.
The MATCH function is often used together with INDEX to provide row and column numbers….
