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 i...
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.
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.