Excel INDEX Function: How to Use It, with Examples Turkish: İNDİS
Returns the value at a given row and column of a range. Combined with MATCH it can do any lookup, including looking to the left, which VLOOKUP cannot.
INDEX syntax
=INDEX(array, row_num, [column_num])
In Turkish Excel: =İNDİS(dizi; satır_sayısı; [sütun_sayısı])
Argument
Description
array
The range to return a value from.
row_num
The row position in the range.
[column_num]
The column position in the range.
INDEX 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
=INDEX(A2:D6,3,1)
Result: Eraser
Value in row 3, column 1 of the range.
=INDEX(D2:D6,MATCH("Eraser",A2:A6,0))
Result: 2
Price of Eraser with INDEX + MATCH.
Results were calculated in real Excel.
Tips for INDEX
Use 0 as the last argument of MATCH for an exact match.
Related functions
More formula guides
More tools
About INDEX Function
Returns the value at a given row and column of a range. Combined with MATCH it can do any lookup, including looking to the left, which VLOOKUP cannot.
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 INDEX Function
Type the formulaStart typing =INDEX( 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 INDEX in Turkish Excel?
In Turkish Excel, INDEX is called İNDİS. Turkish Excel also separates arguments with semicolons (;) instead of commas.
Which Excel versions have INDEX?
INDEX is available in all current Excel versions (2010 and later, Microsoft 365).