With A1 the activecell, you could use:
=isna(a1)

You may want to modify your =vlookup() formula, too:

=if(isna(vlookup(...)),"",vlookup(...))



Jman1018 wrote:

I have a VLOOKUP looking up a value on another sheet. I works fine but when
it can't find the value it shows a #N/A. I don't want to see the #N/A in any
of the feilds on this sheet and I know I need to do a conditional format and
turn the text to the same color as the backgroud color. I just don't know
the correct "Formula Is" statement.
--
Jman1018

--

Dave Peterson