First time here? Check out the FAQ!
x

How to identify "#N/A" in a formula in Excel 2003?

+1 vote
asked by
edited by

Sometimes a formula in Excel 2003 returns #N/A (like VLOOKUP formula) and I want to know how to identify this "#N/A".
For example, I want to hide #N/A like this:
=if(VLOOKUP(;;***)=#N/A;valueiftrue;valueiffalse). But this will return invariable #N/A.

Thanks for help.

2 Answers

0 votes
answered by (8.2k points)

N/A comes when the data range you have used has incorrect or invalid input. Try the IF range or COUNTIF range for pulling up the data ranges.

–1 vote
answered by (100k points)
edited by

Excel returns these errors when an element inside a formula is wrong, missing or not available. For a formula to work properly and to display the correct results, all elements from the formula must have correct values. On the other hand, #N/A errors are encountered when Excel cannot find a match for the value it's been told to find and it displays that message.

In order to avoid this error please use IF or COUNTIF instead of VLOOKUP and you will see the results will improve.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...