Error: #N/A
Why: #N/A errors happen mostly when a lookup function can't find the value you requested. In a Vlookup function, if the value you are
looking up is not in the leftmost column of the table, you will receive this error. Also, if you are using a function that required
matching size ranges like the CORREL function and your ranges do not match, you will also see the #N/A error.
Example: In our example, "Fev" was not found in the data table. Editing the formula would show the typo and allow us to correctly use
"Feb" which would return the appropriate value.
Solution: Correct this error by verifying your value is contained in the lookup area or by making sure your range sizes are equal.
Author
Posts
You must be logged in to reply to this topic.
By visiting our site, you agree to our privacy policy regarding cookies, tracking statistics, etc.
30 DAY
Money Back
Guarantee
Wait! Save 30%
I'm so Confident you'll Benefit From my Course, I would like to offer you a money back guarantee! Sincerely, "Neil Parsont"