How to Use MATCH Function in Excel

In this Excel Function Explained video series, I will explain, how to use MATCH function in Microsoft Excel. This function search for a value from a predefined array or data range. If it finds the value there then it will return the position of that value in the array. It always returns number as results unless there is an error.

Let’s learn how to use MATCH formula in excel.

The Function looks like this =MATCH (Lookup Value, Lookup Array, Match Type)

The MATCH function has three arguments or parameters and they are explained below.

1. Lookup Value: This is the value you want to find out from the array. Now you can write the value directly inside the formula or you can select a cell containing the value.

2. Lookup Array: This is the data range where excel will try to match the value provided in the first parameter.

3. Match Type: You can select -1 if you are looking for a value less than or equal to your Value. You can use +1 if you are looking for a value getter than or equal to your Value. You can also select Zero if you need to find exact match.

Important facts of Match Function in MS Excel

1. Match function is not case sensitive
2. It will always return number as results unless there is an error
3. You can use wildcard in this function
4. Match function will return the first position number if it finds several match in the array.

This is how we use MATCH in excel. Remember, using MATCH function in excel you actually tell excel formula to check if the value you specified matches the data range or not. If yes then return the position of that value. If it is not there, this function will display an error message.

#Excel #Function #MATCH

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media: