close
how do avoid displaying #na when vlookup funcion is used and value does not
exist in the 'looked up' table?
=IF(ISNA(YourFormula),quot;quot;,YourFormula)
--
Kind regards,
Niek Otten
quot;monia13quot; gt; wrote in message ...
gt; how do avoid displaying #na when vlookup funcion is used and value does not
gt; exist in the 'looked up' table?
全站熱搜
留言列表
