Conditional Formatting of #n/a result

  • Thread starter Thread starter sstook
  • Start date Start date
S

sstook

I am using a vlookup function which, when it returns the
#n/a result I would like to format conditionally, i.e. if
it is #n/a, blank out the cell. How would I do this?
 
No need to blank anything out. Just add to your formula to get something
like this (copy from here and paste into your formula bar) :-

=IF(ISERROR(VLOOKUP(A1,$B$10:$C$100,2,FALSE)),0,VLOOKUP(A1,$B$10:$C$100,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

#N/A Conditional Formatting affects all cells? 9
Conditional format Formula -Duplicate & n/a 1
Conditional Formatting - recognise #N/A 3
Using VLookup and format the #N/A result 2
Conditional Format Help 1
conditional format on cells using VLOOKUP 5
Conditional Format 1
#N/A 5

Back
Top