Excel MATCH Function: How to Use It, with Examples Turkish: KAÇINCI
Returns the position of a value in a row or column (which cell it is in).
MATCH syntax
=MATCH(lookup_value, lookup_array, [match_type])
In Turkish Excel: =KAÇINCI(aranan_değer; aranan_dizi; [eşleştir_tür])
Argument
Description
lookup_value
The value to find.
lookup_array
The single row/column to search.
[match_type]
0 = exact match; 1 or -1 = approximate match in a sorted list.
MATCH examples
Sample table:
A
B
C
D
1
Product
Region
Quantity
Price
2
Pen
Ankara
12
5
3
Notebook
İzmir
8
20
4
Eraser
Ankara
30
2
5
Notebook
Ankara
5
20
6
Pen
İzmir
7
5
=MATCH("Eraser",A2:A6,0)
Result: 3
Which position is Eraser in the list?
Results were calculated in real Excel.
Tips for MATCH
Usually used together with INDEX rather than on its own.
Related functions
More formula guides
More tools
About MATCH Function
Returns the position of a value in a row or column (which cell it is in).
Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.
How to use MATCH Function
Type the formulaStart typing =MATCH( in a cell; Excel shows the arguments.
Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
Press EnterCheck the result; you can also try it in the tester below.
Frequently asked questions
What is MATCH in Turkish Excel?
In Turkish Excel, MATCH is called KAÇINCI. Turkish Excel also separates arguments with semicolons (;) instead of commas.
Which Excel versions have MATCH?
MATCH is available in all current Excel versions (2010 and later, Microsoft 365).