whiting out error messages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a worksheet that will has very many error messages (#N/A). These
messages are the result of a Vlookup that's supposed to get its input from a
dropdown, only the dropdown may or may not get selected. I need to make it
where the error messages are just whited out and you can't see them.

thank you
 
If you need the #N/As, use Conditional Formatting:

Format/Conditional Formatting...
CF1: Formula Is =ISNA(A1)
Format: (Font color = background color)

If you don't need the #N/A's, then you're probably better off
eliminating them from your sheet:

=IF(ISNA(MATCH(A1,J:J,FALSE)),"",VLOOKUP(A1,J:K,2,FALSE))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want only rows with populated data 1
#REF! trying to white out 3
errors using Vlookup 1
Email Bounce Error 3
opaque white rectangle in lower corner of screen above taskbar 1
VLOOKUP -- Table Array Problem 1
Samsung TV new wont put enough signal out power for sound bar? 10
Conditional Formatting and dropdowns 3

Back
Top