How to find every #n/a error from vlookup and index/match with a cell-by-cell report
- Step 1Upload the workbook after a data refresh — Drop the .xlsx after new data caused VLOOKUP failures.
- Step 2Review the #N/A error report — Every #N/A cell is listed with its formula. The lookup value that wasn't found is visible in the formula.
- Step 3Fix missing lookup values or update formulas — Add missing rows to the lookup table, or update the lookup range. Re-run the locator to confirm zero errors.
Frequently asked questions
How can I tell which lookup value caused the #N/A from the formula shown?+
The formula shows the lookup_value reference: =VLOOKUP(A5,$B:$D,2,0) — navigate to cell A5 to see the value that wasn't found in column B.
Does the tool find #N/A inside IFERROR() wrappers?+
No. IFERROR-wrapped cells show their fallback value and are not flagged as errors. Only cells displaying the raw #N/A code are detected.
Can I use the report to build a list of missing lookup values?+
Yes. The formula column shows the lookup_value for each #N/A. Extract those references to identify which values are missing from your lookup table.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.