Why is VLOOKUP returning #N/A when the value exists?

Ask Mini NOVA, then check the lookup

Start with the sheet open. The checks below are the ones Microsoft Support lists for a #N/A error from VLOOKUP, XLOOKUP, HLOOKUP, LOOKUP, or MATCH.

1. Leave the error on screen. Keep the message, the formula bar, or the settings page in view. Mini NOVA captures the screen when you submit the question, so scroll until the error and a little of the window around it are visible.
2. Press Insert and type your question. Press Insert, then type what you want to know. Mini NOVA sees that screen and guides you step by step. You make the click. There is no server or browser extension to set up, and no Microsoft 365 plan is needed.
3. Change one thing, then look again. You make the change. If the error is still there, ask a follow-up with the new screen visible. Mini NOVA remembers the conversation context. There is no chat history list.
4. Confirm the value is inside the range. Read the range in the formula and compare it with the cells where you can see the value. Microsoft Support says the usual cause is that the lookup value is not in the source data the formula searches. If the range has moved, or it starts to the right of the column that holds the value, the function is not looking at the cell you think it is.
5. Ask for an exact match. For VLOOKUP and HLOOKUP, set the range_lookup argument to FALSE. TRUE, or leaving that argument out, asks for an approximate match and can return #N/A or the wrong row. For MATCH, an exact match is match_type 0.
6. Remove extra spaces. A value that looks the same can still fail when a cell has a leading or trailing space. Microsoft Support shows TRIM around the lookup table, for example =VLOOKUP(D2,TRIM(A2:B7),2,FALSE). In current Microsoft 365 you can enter that and press Enter. In older versions you may need Ctrl+Shift+Enter. You can also delete the extra spaces in the cells themselves.
7. Make the types match. A number in one cell and the same digits stored as text in another are not a match. Select the cells, right-click, choose Format Cells, then Number, or press Ctrl+1. To push a format through a whole column, apply the format, then on the Data tab choose Text to Columns and Finish.
8. Hide #N/A only after the lookup is right. IFERROR can show 0, a blank, or your own text when the lookup fails, for example =IFERROR(VLOOKUP(...),"Not in the table"). Use that when a missing value is expected. It will also hide a range, space, or type problem you have not fixed yet.

Same screen, other formula errors

If the cell says #REF!, the formula points at a cell that is no longer valid. #SPILL! means the result needs empty cells. #VALUE! means a value is the wrong kind for the formula. The spreadsheet guide covers asking about the sheet you already have open.

Sources

Checked on 9 Oct 2026. Support pages change, so open the source before you rely on a step. Mini NOVA is not affiliated with Microsoft. Questions about the account itself go to admin@deskwithnova.com.

• How to correct a #N/A error (Microsoft Support)
• Spreadsheet formulas on your screen

FAQ