assign #N/A to blank?

[Cam]

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

 

[Pete_UK]

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