Here's how to use Excel's MATCH function to find the position of a value in a row, column, or table. This is useful when you need to find the position of the item in the list rather than the item itself.

The syntax of a function refers to the layout of the function and includes the function name, parentheses, comma separators, and arguments. The syntax for the MATCH function is:

Each input you give to a function is called an argument. Most functions in Excel require some input or information to calculate correctly.

These are the arguments of the MATCH function: