Excel Tutorial – XMATCH

The XMATCH function in Microsoft Excel is a function that searches for a value in a range of cells and returns the relative position of the value in the range. This function is similar to the VLOOKUP function, but it allows you to specify the match type (exact, approximate, or wildcard) and returns the position of the value instead of the value itself.

To use the XMATCH function, follow these steps:

1. Open Microsoft Excel and select the cell where you want the result to appear.
2. Type the following formula into the cell: =XMATCH(lookup_value, lookup_array, match_type)
3. Replace “lookup_value” with the cell reference or value that you want to search for.
4. Replace “lookup_array” with the cell reference or range of cells that you want to search in.
5. Replace “match_type” with the number 1, 0, or -1 to specify the match type:

• 1: Exact match
• 0: Approximate match
• -1: Wildcard match

6. Press Enter to see the result.

The XMATCH function searches for the lookup value in the lookup array, using the specified match type, and returns the relative position of the value in the range. If the value is not found, the function returns the #N/A error.

You can use the XMATCH function to search for values in a range of cells and return the position of the value in the range. It is a very useful tool for working with data in Excel.