Hi all,

This is my first post to the forum.

Is there anyway to hide the #N/A value displayed if no data is available on a vlookup? Sometimes the spreadsheet I am pulling from is not fully populated.
I would like the cell to be blank instead of having the #N/A error.


Thanks for your advice,
Jim