ExcelFlux

MATCH function

Find the position of an exact employee ID.

Lookup and reference

Where can you use it?

Reporting and operations teams. Use functions in this group to retrieve a field from an item, employee or order list, select the right record, or move values into another report.

Scenario in the workbook

Return the relative position of an exact match, counting from one.

A worked example from the workbook

RowAB
6ValueComparison
722
855
900
Record 1
=MATCH(A7,$B$7:$B$9,0)

Expected result1

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=MATCH("P-102",A2:A4,0)
Turkish Excel · tr-TR
=KAÇINCI("P-102";A2:A4;0)

Example and expected result

Enter P-101, P-102 and P-103 in A2:A4. The final 0 requests an exact match.

Expected result 2.

Worked examples

Return the relative position of an exact match, counting from one.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Value Comparison
7 2 2
8 5 5
9 0 0
Case Formula Expected result
Record 1 =MATCH(A7,$B$7:$B$9,0) 1
Record 2 =MATCH(A8,$B$7:$B$9,0) 2
Record 3 =MATCH(A9,$B$7:$B$9,0) 3
Microsoft Excel reference