A Error
Problem
When VLOOKUP can't find a value in a lookup table, it returns the #N/A error.
Solution
To hide the #N/A error that VLOOKUP throws when it can't find a value, you can use the IFERROR function to catch the error and return any value you like.
=IFERROR(VLOOKUP(value,table,2,FALSE),"")
