VlookUp and blank fields

Resolved · Medium Priority · Version 2010

Fri 23 Sep 2011, 16:07 Delegate 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:00 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips