Turning #N/A into an empty cell

T

Thansal

I have a VLOOKUP formula running that will generaly return #N/A because
I am just trying to get some data on a few cells from a rather large
group.

Is there some way to automaticly turn this error into an empty cells or
somethign equivilant?
 
N

nstrom

Thansal said:
I have a VLOOKUP formula running that will generaly return #N/A because
I am just trying to get some data on a few cells from a rather large
group.

Is there some way to automaticly turn this error into an empty cells or
somethign equivilant?
Click to expand...

Use the ISNA function inside an IF clause. ie.

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

ISERROR also works but will trap any error cells.
 
Top