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?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄