MATCH function in Excel

Syntax

=MATCH(lookup_value, lookup_array, [match_type])

Example

=MATCH("Monitor",B2:B6,0) returns 4 because Monitor is the 4th item in B2:B6.

From the lesson MATCH Function.

Common mistakes

• Leaving out 0, which gives an approximate match.
• Counting from the sheet row instead of from the start of the range.

Related lookup functions

• VLOOKUPLooks down the first column of a table and returns a value from another column.
• HLOOKUPLooks across the first row of a table and returns a value from another row.
• XLOOKUPFinds a value in one range and returns the matching item from another.
• INDEXReturns the value at a given row and column of a range.
• XMATCHPosition of a value in a list; exact match by default.