VLOOKUP without N/A Error

From Rockcliffe Library Network
Jump to: navigation, search

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