VLOOKUP without N/A Error

From Rockcliffe Library Network
Jump to: navigation, search


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.