Forum home » Delegate support and help forum » Microsoft Excel Training and help » VlookUp and blank fields
|
|
|
The UK's most regular 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. |
VlookUp and blank fields
Resolved · Medium Priority · Version 2010
Reply Fri 23 Sep 2011, 16:07Delegate Michelle said...
Michelle has attended:
Excel Advanced course
VlookUp
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
For upcoming training course dates see: Pricing & availability
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.
|