assign #N/A to blank?
 

Hello,

I have some cells with Vlookup formula that return #N/A value. How can I
tell it to show blank when it returns #N/A? Thanks

assign #N/A to blank?
 

Like this:

=IF(ISNA(your_formula),"",your_formula)

i.e. if your formula returns #N/A then return a blank, otherwise
return what your formula returns.

Hope this helps.

Pete

On Aug 19, 4:06*pm, Cam wrote:
Hello,

I have some cells with Vlookup formula that return #N/A value. How can I
tell it to show blank when it returns #N/A? Thanks