Forum Discussion
maggieb777
Sep 18, 2025Occasional Reader
Leaving a blank space
I am using Vlookup to find data on a different tab of an excel sheet.
If there something I can put in the Vlookup formula to show a blank space in place of a "#N/A" if there is no data in the cell it is trying to look up?
Example below - the vlookup formula is in the 3rd column. since there is no data in the 2nd column, i would like the 3rd column to be blank instead of showing the #N/A
W | 1424 | BIRKDALE | 8 | |||
TH | 1450 | ROUND MEADOW | 8 | |||
F | 1450 | ROUND MEADOW | 7 | |||
SAT | #N/A |
1 Reply
- SnowMan55Bronze Contributor
There are multiple possibilities, of which I prefer to avoid any unnecessary lookups:
=IF( B5="", "", VLOOKUP(B5, Examples!$G$3:$H$6, 2) )
See the attached workbook for more possibilities.