XLOOKUP IF not Found Return Blank
The #N/A error is useful for debugging, but it looks messy in reports and shared sheets. XLOOKUP has a built-in argument for what to show when nothing is found. This guide shows how to return a blank instead of an error for missing SKUs.
Formula Syntax
Use this base syntax for xlookup if not found return blank and replace the ranges with your own spreadsheet columns.
XLOOKUP(lookup_value, lookup_array, return_array, "")Need this formula for your exact sheet?
Generate a custom xlookup if not found return blank formula with your own columns, criteria, and spreadsheet layout.
Step-by-step Example
A warehouse control spreadsheet tracks SKU lookup cleanup and needs a formula-driven result instead of manual filtering.
| SKU | Price |
|---|---|
| SKU-001 | $12 |
| SKU-002 | $18 |
| SKU-003 | $25 |
Resulting formula
=XLOOKUP(E2,A:A,B:B,"")The formula evaluates the SKU lookup cleanup rows and returns Blank if missing. Replace the sample ranges with your actual columns, then adjust the criteria so the result matches your workbook.
Try It Now
The generator is pre-filled for xlookup if not found return blank. Edit the prompt to match your columns, criteria, and spreadsheet layout.
Generated formula
How it works
Need more formulas every day?
HelpFormula Pro is $7.99/mo for faster spreadsheet work across Excel and Google Sheets.
- ✓ Higher daily formula generation limits
- ✓ Saved formula history for reuse
- ✓ Excel formula language selection
Common Variations
- Return blank if missing
- Return zero if missing
- Return custom message
FAQ
How do I set up XLOOKUP IF not Found Return Blank for SKU lookup cleanup?
Map the sample columns to your own sheet first, then replace the formula ranges with the real ranges from your workbook. Keep text criteria in quotes and verify that date or number columns are stored as real values.
Can this formula handle return blank if missing?
Yes. Use the same formula pattern and change the criteria, helper column, or lookup value for return blank if missing. If the logic becomes more complex, generate a custom version with the free tool.
What should I check if the XLOOKUP IF not Found Return Blank result is wrong?
Check that every referenced range covers the same rows, locked references use dollar signs where needed, and the criteria type matches the data. For this page, also confirm that the SKU lookup cleanup fields are formatted consistently.