Look Up a Value to the Left

Excel Formulas › Lookup

All versionsINDEX/MATCH

VLOOKUP can only look rightward. To return a value from a column to the left of the match, use INDEX/MATCH (or XLOOKUP), which don’t care about column order.

Quick formula: the key is in column C; return the name from column A:
=INDEX(A:A, MATCH(E2, C:C, 0))
MATCH finds the row of the key in column C; INDEX returns that row from column A — left of the lookup column.

Functions used (tap for the full reference guide):

INDEXMATCH

The example

Find the name (col A) by ID (col C).

ABC
1NameDeptID
2AnnSales102

The formula

INDEX returns any column; MATCH finds the row:

=INDEX(A:A, MATCH(E2, C:C, 0)) // return col A by a key in col C

How it works

Decouple “where to look” from “what to return”:

  1. MATCH(key, C:C, 0) returns the row number where the key sits (exact match).
  2. INDEX(A:A, thatRow) returns the value from column A at that row — which can be left of, right of, or anywhere relative to the key.
  3. Because INDEX and MATCH reference columns independently, there’s no “leftward” restriction.
  4. In 365/2021, XLOOKUP(E2, C:C, A:A) does the same — the return array can be any column.

INDEX/MATCH is the classic workhorse. It does left lookups, is faster than VLOOKUP on wide tables (it only reads two columns), and doesn’t break when columns are inserted. XLOOKUP is the modern equivalent where available.

Try it: interactive demo

Live demo

Find the name by ID (name is left of ID).

Name:

Variations

XLOOKUP version

365/2021:

=XLOOKUP(E2, C:C, A:A)

Two-way INDEX/MATCH

Row and column:

=INDEX(grid, MATCH(r, rows, 0), MATCH(c, cols, 0))

Return whole row

Omit the column:

=INDEX(A2:C100, MATCH(E2,C2:C100,0), 0)

Pitfalls & errors

MATCH needs exact mode. Use 0 as MATCH’s third argument for an exact match; omitting it assumes sorted data and can return wrong rows.

Align INDEX and MATCH ranges. The INDEX column and the MATCH column should cover the same rows, or the row number won’t line up.

Whole-column refs are fine but heavier. A:A works; restrict to the data range on huge sheets for speed.

Practice workbook

📊
Download the free Look Up a Value to the Left practice workbook
A left-lookup sheet with live INDEX/MATCH, the XLOOKUP and two-way variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I look up a value to the left in Excel?
Use INDEX/MATCH: =INDEX(returnColumn, MATCH(key, lookupColumn, 0)). Unlike VLOOKUP, it can return a column left of the key. In 365/2021, =XLOOKUP(key, lookupColumn, returnColumn) also works.
Why can't VLOOKUP look left?
VLOOKUP returns a column to the right of its lookup column by a positive index. For leftward returns, use INDEX/MATCH or XLOOKUP.
Is INDEX/MATCH better than VLOOKUP?
Often — it does left lookups, reads only two columns (faster on wide tables), and survives inserted columns. XLOOKUP is the modern all-in-one.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Index-match 2D · Two-way lookup · XLOOKUP if not found

Function references: INDEX · MATCH