ExcelFlux

INDEX function

Return an employee name by position.

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 an item by its relative position, which differs from the worksheet row number.

A worked example from the workbook

RowAB
6ValueComparison
712
825
930
Record 1
=INDEX($B$7:$B$9,A7)

Expected result2

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=INDEX(B2:B4,2)
Turkish Excel · tr-TR
=İNDİS(B2:B4;2)

Example and expected result

Enter Deniz, Ada and Ege in B2:B4. Position 2 returns the second item in the range.

Expected result Ada.

Worked examples

Return an item by its relative position, which differs from the worksheet row number.

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 1 2
8 2 5
9 3 0
Case Formula Expected result
Record 1 =INDEX($B$7:$B$9,A7) 2
Record 2 =INDEX($B$7:$B$9,A8) 5
Record 3 =INDEX($B$7:$B$9,A9) 0
Microsoft Excel reference