How do I stop Na in Excel?

by

VLOOKUP without errors # N/A

  1. Generic formula. =SIFERROR(VLOOKUP(value,table,2,FALSE),message)
  2. Summary. To hide the #N/A error that VLOOKUP throws when no value is found, you can use the IFERROR function to catch the error and return the desired value.
  3. If VLOOKUP cannot find a value in a lookup table, the error # N/A is returned.

How to remove Na error in Excel?

To suppress the error, we can use the IFERROR() function introduced in Excel 2007. For the first argument, we use our original Vlookup function. Then we put a comma and write what should be displayed if the vlookup function returns an error.

Exit mobile version