Cascading (Two-Step) Lookups

All versionsVLOOKUP

Look up one value, then use that result to look up another — category → rate, employee → department → budget. Chaining lookups walks a relationship in two (or more) steps.

Quick formula: find an employee’s department, then that department’s budget:

=VLOOKUP(VLOOKUP(A2, empTable, 2, 0), deptTable, 2, 0)

The inner lookup returns the department; the outer one uses it as the key into the department table.

Functions used (tap for the full reference guide):

VLOOKUP INDIRECT

The example

Employee → department → budget.

	A	B
1	Step	Result
2	Ann → dept	Sales
3	Sales → budget	$120,000

The formula

Feed one lookup’s result into the next:

=VLOOKUP(VLOOKUP(A2, empTable, 2, 0), deptTable, 2, 0) // Ann → Sales → $120,000

How it works

The inner result becomes the outer key:

The inner VLOOKUP(A2, empTable, 2, 0) returns the intermediate value (department).
The outer VLOOKUP(thatDept, deptTable, 2, 0) uses it to look up the final value (budget).
Chain more steps the same way, or break them into helper columns for clarity and easier debugging.
For a dropdown that filters another dropdown (dependent lists), pair this with INDIRECT — see the dependent-dropdown recipe.

Helper columns beat deep nesting. Two or three chained lookups in one cell get hard to read and debug. A column for “department,” then a column for “budget,” is clearer and lets you see where a break happens. Collapse to one formula only once it’s proven.

Try it: interactive demo

Live demo

Employee → department → budget.

Employee

Dept · Budget

Variations

Helper columns

Split the steps:

B2: =VLOOKUP(A2, emp, 2, 0) C2: =VLOOKUP(B2, dept, 2, 0)

XLOOKUP cascade

365 version:

=XLOOKUP(XLOOKUP(A2, emp, depts), deptKeys, budgets)

Dependent dropdowns

Pair with INDIRECT for lists.

Pitfalls & errors

Inner miss breaks the chain. If the inner lookup returns #N/A, the outer one fails too — wrap each step (or the whole thing) in IFERROR.

Exact keys throughout. Use exact match (0/FALSE) at every step; a stray space in the intermediate value breaks the next lookup.

Readability. Deep nesting is error-prone — prefer helper columns until the chain is verified.

Practice workbook

📊

Download the free Cascading (Two-Step) Lookups practice workbook

A cascading lookup with live nested VLOOKUP, the helper-column and XLOOKUP variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I do a two-step lookup in Excel?

Nest the lookups: =VLOOKUP(VLOOKUP(key, table1, 2, 0), table2, 2, 0). The inner returns an intermediate value that the outer uses as its key.

Should I use helper columns?

For two or more steps, yes — a column per step is clearer and easier to debug than deep nesting. Collapse to one formula once it works.

What if the first lookup fails?

An #N/A from the inner lookup breaks the outer one. Wrap each step (or the whole formula) in IFERROR to handle misses.

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: Dependent dropdown · INDIRECT reference · Lookup multiple criteria

Function references: VLOOKUP · INDIRECT