#n/A Help to make to blank

[rcirone]

I am get a #N/A when I use this to look up names if it can not find the name. it give me a #N/A. How do I get rid of the N/A. it work find if I am looking up number and if it does not find the number it leave it blank. I like it to do the same thing for names look ups.

=IF($A$3="","",VLOOKUP($A3,'<wbr style="font-family: Arial, Helvetica, sans-serif; font-size: small;">CASS-Appointment'!$B$9:$H$53,<wbr style="font-family: Arial, Helvetica, sans-serif; font-size: small;">7,FALSE))

 

[edgarsrom]

Try:

=IF(ISNA(VLOOKUP($A3,'<wbr style="color: rgb(51, 51, 51); font-size: small; background-color: rgb(250, 250, 250); font-family: Arial, Helvetica, sans-serif;">CASS-Appointment'!$B$9:$H$53,<wbr style="color: rgb(51, 51, 51); font-size: small; background-color: rgb(250, 250, 250); font-family: Arial, Helvetica, sans-serif;">7,FALSE))),"",VLOOKUP($A3,'<wbr style="color: rgb(51, 51, 51); font-size: small; background-color: rgb(250, 250, 250); font-family: Arial, Helvetica, sans-serif;">CASS-Appointment'!$B$9:$H$53,<wbr style="color: rgb(51, 51, 51); font-size: small; background-color: rgb(250, 250, 250); font-family: Arial, Helvetica, sans-serif;">7,FALSE)))

 

[sandy666]

or =IFNA(your_formula,"")

 

[rcirone]

I am still getting the #N/A this may help the format for the name is ('Mickey Mouse)

 

[rcirone]

that does not work too
I get #NAME

 

[sandy666]

in the first post you should show your Excel version
if you see #NAME so probably you've 2010 or less

 

[rcirone]

ver 2010

 

[sandy666]

so IFNA doesn't work on your version
you can check here: IFNA()

but =IFERROR(your_formula,"") should work