=if(isna(your vlookup goes here),"",your vlookup goes here again)

"Pablo" wrote:

I am doing a Vlookup and it is returning a #N/A when the reference value does
not exist. Is there function to convert the to " "? The reasoning is that
#N/A is kind of ugly and I have a couple other formulas testing for a " ".

Thanks,