Search results
Results from the WOW.Com Content Network
How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.
MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. Often, MATCH is combined with the INDEX function to retrieve a value at a matched position.
The MATCH function is a lookup/reference function of Excel. It looks up for a given value in a look-up array. And if found, it returns the relative position of the lookup value in the lookup array.
Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more. Skip to main content
The MATCH function in Excel searches for a specified value in a range of cells, and returns the relative position of that value. The syntax for the MATCH function is as follows: MATCH(lookup_value, lookup_array, [match_type])
The MATCH function in Excel is used to locate the position of a lookup value in a row, column, or table, and returns the relative position of an item in an array that matches a specified value in a specified order.
When you need to find a value's exact position in your spreadsheet, you can use the MATCH function in Excel. This saves you from manually searching for the location that you may need for reference or another formula. The MATCH function is often used with the INDEX function as an advanced lookup.