Microsoft Excel MATCH() Function

 To use Microsoft Excel's MATCH() function, which returns the relative position of an item in a range that matches a specified value, follow these steps:

Open Excel: Launch Excel and open the worksheet containing the data you want to work with.

Select a cell: Click on the cell where you want the result of the MATCH() function to appear.

Type the function: In the selected cell, type =MATCH( to start the function.

Enter the lookup value: After typing =MATCH(, enter the value you want to search for. This is the value you want to find within the specified range.

Specify the lookup array: After entering the lookup value, specify the range of cells where you want Excel to search for the value. This is the range where Excel will look for the specified value.

Specify the match type (optional): Enter 0 or FALSE for an exact match, 1 or TRUE for the largest value less than or equal to the lookup value, and -1 for the smallest value greater than or equal to the lookup value. If you omit this argument, Excel will default to an exact match.

Close the function: Close the parentheses ) to complete the function.

Press Enter: After closing the parentheses, press Enter to execute the function. The result will appear in the selected cell, showing the relative position of the specified value within the lookup array.

Here's an example:

Suppose you have a list of fruit names in cells A1 to A5, and you want to find the position of the fruit "Banana".

=MATCH("Banana", A1:A5, 0)

This formula will return the relative position of "Banana" within the range A1:A5. If "Banana" is in the third position in the list, the formula will return 3. If "Banana" is not found, the formula will return an error.