Menu
EXCEL MATCH FUNCTION
Excel MATCH Function Introduction
This function looks for a given product in a range of cells and returns the relative location of that item in the range. For example, if the range A1:A3 contains the numbers 8, 39, and 54, then the formula =MATCH(39,A1:A3,0) yields the number 2, as 39 is the second item in the range.
Description of Excel MATCH Function
Syntax:
=MATCH (lookup value, lookup array, [match type])
parameterslist :
- lookup value – the lookup array value to match. lookup array – a cell range or an array reference.
- match type – [obligatory] Matching method, defined as -1, 0 or 1. The default value is 1. list
Step By Step Guide of MATCH Function
Example :
In this example, we are first determining the position of the item Papaya among these Six Fruit Items. As you can see, Papaya is in fifth place, so the answer is 5.
Key Points
Important points to consider. Match does not care about case. If no match is discovered, Match returns the #N/A error. If match type is 0 and lookup value is text, the wildcard characters asterisk (*) and question mark (?) can be used. An asterisk represents any sequence of characters, whereas a question mark represents any single character.
Excel MATCH Function Template/Exercise
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
