=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten

"monia13" wrote in message ...
how do avoid displaying #na when vlookup funcion is used and value does not
exist in the 'looked up' table?