VLOOKUP hide NA help

[MWhiteDesigns]

Hey Guys,

I have a quick question, hopefully you can help. I have a VLOOKUP i am using. When i Drag it to the other cells, if there isnt anything in Column A, i receive an #NA error. How do i make this error not show and just show a blank cell.

The Forumula I am using is:
=VLOOKUP(A2,Lists!A2:AG1500,2,FALSE)

Any quick help will be great. I need to show this form in 30 minutes to my manager. Thank you!

 

[VoG]

Try

=IF(A2="","",VLOOKUP(A2,Lists!A$2:AG$1500,2,FALSE))

 

[MWhiteDesigns]

AHA! Thank you so much!

 

[edany]

In Excel 2010 it can be done with Contional Formatting. Take a look at this link how to do it:
http://practicaladvices.blogspot.com/2011/11/how-to-hide-na-result-in-excel-2010.html