I have a Vlookup that is returning the value #N/A. Is there a way to enter a conditional format:
=If(a1="#N/A",1,0)
I tried this equation and it did not work.
Is there anyway to work around this?
I have a Vlookup that is returning the value #N/A. Is there a way to enter a conditional format:
=If(a1="#N/A",1,0)
I tried this equation and it did not work.
Is there anyway to work around this?
Last edited by mcantrell; 08-16-2010 at 03:53 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks