FormulaCraft

INDEX

INDEX returns the value at a specific row (and optionally column) position inside a range. On its own it grabs the nth item; with MATCH it powers two-way lookups that beat VLOOKUP.

Excel
=INDEX(B2:B4, 2)
Google Sheets
=INDEX(B2:B4, 2)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

ProductPrice
Pen2
Book8
Bag25

=INDEX(B2:B4, 2)→8

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1B2:B4 is the range to pull a value from.
  2. 22 is the position within that range.
  3. 3INDEX returns the 2nd value (here, 8).

Need a version for your data?

Try: “Return the 2nd price from the price column”

Related

VLOOKUPXLOOKUPINDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: