This blog article will show you how to apply the Excel Match function. Learn how to use this powerful tool to analyse data and make decisions fast and simply. Learn how to implement Match in Excel in various ways and how to apply it to your own data.
The Excel MATCH function is a lookup function that searches for a specified item in a range of cells and returns the relative position of the item in the range.
Syntax
MATCH(lookupValue, lookupArray, [matchType])lookupValue: The value to search for in the lookupArray.
lookupArray: The range of cells to search for the lookupValue.
matchType: [optional] The type of match to use. 0 or omitted for an exact match, 1 for an approximate match.
The Match function returns the relative position of the lookup Value in the lookupArray. If the lookupValue is not found, the function returns the #N/A error.
Example
If you have an employee’s name in your database column B in Excel. Create a user input to enter the name of the employee and check, whether the name is in your employee list or not.
Please follow the below steps to create user input and check
Format the cells D3 to E4 as below, where cell D4 is an input. The user enters the name in cell D4.
Type the formula =MATCH(D4, B2:B11, 0) in cell E4, which checks the name in the list and returns the position if it matches, else it returns an #N/A error.
Example 1. Enter the Name Christopher Tran in cell D4, match function returns 2 the position of the name in your list.
Example 2. Enter the Name John in cell D4, Match function returns #N/A since the name is not in your employee list.
Conclusions
Excel functions are a wonderful tool for saving time and making your work simpler. With a little experience, you can become an Excel master and apply functions to analyse data fast and effectively.
Learning how to apply Excel functions may help you become more effective and productive, whether you are a new or an experienced user. You may become an Excel expert and use functions to your advantage with the relevant research and practice.
If you have any questions, please leave a comment below and I will get back to you as soon as possible.
