Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to write a nested VLOOKUP in Excel and Google Sheets
Topic:VLOOKUPExcel & Google Sheets
=VLOOKUP(VLOOKUP(A2,$C$2:$D$5,2,FALSE),$F$2:$G$5,2,FALSE)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
Step by step
- 1Set up Table 1 (e.g. C2:D10) mapping an ID to a category code, and Table 2 (e.g. F2:G10) mapping that category code to a final description.
- 2Write the inner VLOOKUP to retrieve the category code: VLOOKUP(A2,$C$2:$D$10,2,FALSE).
- 3Nest it as the lookup_value of the outer VLOOKUP: =VLOOKUP(VLOOKUP(A2,$C$2:$D$10,2,FALSE),$F$2:$G$10,2,FALSE).
Tips
- If either lookup can fail, wrap the whole formula in IFERROR to avoid cascading #N/A errors: =IFERROR(VLOOKUP(VLOOKUP(...),...),"Not found").
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Is there a cleaner alternative to nested VLOOKUP?
Yes. INDEX/MATCH chains are often easier to read, and in Excel 365 or Google Sheets you can chain XLOOKUP calls which have a built-in not-found argument.
More on VLOOKUP
See all →Reference
VLOOKUP
Look up a value in the first column of a range and return a value from another column in the same row.
How-toHow to VLOOKUP from another sheet
Pull a value from a different tab with VLOOKUP by prefixing the range with the sheet name. Works in Excel and Google Sheets.
Error fixFix #N/A
Fix #N/A errors in VLOOKUP in Excel and Google Sheets — covers missing matches, extra spaces, data-type mismatches, and range mistakes.
How-toHow to VLOOKUP with multiple criteria
Look up a value that matches two or more conditions using INDEX/MATCH with joined keys. Works in Excel 365 and Google Sheets.
Error fixFix Wrong value
VLOOKUP returns an incorrect value in Excel and Google Sheets — fix wrong column index, approximate match mode, unsorted data, and duplicate lookup keys.
How-toHow to fix VLOOKUP returning #N/A
VLOOKUP shows #N/A when it can’t find a match. Here are the real causes — exact-match, spaces, text-vs-number — and how to fix each.