98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Look ups
Look ups
Resolved · High Priority · Version 2003
Mon 7 Jun 2010, 15:22Delegate Anna said...
Anna has attended:
Excel Advanced course
Look ups
While using vlookup I got an error message #N/A when a sheet does not have any results for searched id. Could it be replaced with 0 instead of NA?
thanks
Anna
Thu 10 Jun 2010, 14:57Trainer Simon said...
RE: Look ups
Hi Anna,
Thank you for your question and welcome to the forum.
You need to use a Nested function similar to the one below:
=if(iserror(vlookup(b2,e5:H15,3,false)),0,vlookup(b2,e5:H15,3,false))
The iserror function handles a host of error messages which include #N/A.
So the formula is saying, if there is an error from the vlookup formula, place a zero otherwise put the result of the vlookup formula.
I hope this answers your question.
Regards
Simon
Thu 17 Jun 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using Alt in Save Dialog BoxWhen you are saving (or opening) a file, try these; |
