Works great! Thank you.
--
Jman1018


"John C" wrote:

You could just change your formula.
=IF(ISNA(VLOOKUP(...,...,...,FALSE)),"",VLOOKUP(.. .,...,...,FALSE))
--
** John C **


"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