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),"")

Cookies help us deliver our services. By using our services, you agree to our use of cookies.