Why not do this instead?
=IF(ISNA(VLOOKUPHERE),"",VLOOKUP)
That way, if it's #N/A, then it shows nothing in the cell.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Wendy" wrote in message
...
I would like to format the '#N/A' results (from a VLookup) in a column to
be
white or invisible, but because it is neither a value or a formula, I am
having trouble. Any ideas?