assign #N/A to blank?

C

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
 
P

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
 
Top