How to Remove NA Error From VLOOKUP
The Video above explains how to use the Frequency Formula of MS Excel. The Text below is from a Microsoft Excel Support Blog
The most common cause of the #N/A error is with VLOOKUP, HLOOKUP, LOOKUP, or MATCH functions if a formula can’t find a referenced value. For example, your lookup value doesn’t exist in the source data.
In this case there is no “Banana” listed in the lookup table, so VLOOKUP returns a #N/A error.
Solution: Either make sure that the lookup value exists in the source data, or use an error handler such as IFERROR in the formula. For example, =IFERROR(FORMULA(),0), which says:
- =IF(your formula evaluates to an error, then display 0, otherwise display the formula’s result)
You can use “” to display nothing, or substitute your own text: =IFERROR(FORMULA(),”Error Message here”)