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").
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
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.