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
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
