A Error


When VLOOKUP can't find a value in a lookup table, it returns the #N/A error.


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.


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