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 » VlookUp and blank fields
VlookUp and blank fields
Resolved · Medium Priority · Version 2010
Fri 23 Sep 2011, 16:07Delegate Michelle said...
Michelle has attended:
Excel Advanced course
VlookUp and blank fields
Want to know how to get rid of the #N/A in a lookup so that if the data is not found the field is blank
Sun 25 Sep 2011, 16:00Trainer Rodney said...
RE: VlookUp
Hello Michelle,
Hope you enjoyed your Microsoft Excel Advanced course with Best STL.
Thank you for your question regarding how to get rid of the #N/A error when using Vlookup.
Assuming that your formula is as follows:
=VLOOKUP(A6,Tran_info,2,FALSE)
Edit this by adding the IFERROR( function after the = sign followed by a comma after the last bracket then "")
The formula will then become as follows:
=IFERROR(VLOOKUP(A6,Tran_info,2,FALSE),"")
If there are any #N/A errors, these will be replaced by a blank ("") as you wanted. Try it and see...
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Sun 2 Oct 2011: 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:Printing spreadsheets without opening them firstHere's a fast way of printing a spreadsheet from Windows Explorer/My Computer. |
