Highlights
- Match function syntax
- Explore Match function examples
- Create a largest value Match function lookup
MATCH can be used instead of a LOOKUP function when you need to determine the position of a value in a list instead of the value itself.
As an example, you may use the MATCH function to provide a value to be used in the row_num argument of the INDEX function.