Forum Discussion
Solved
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 |
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.
1 Reply
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.