Blanking cells with formula errors

[Richard Layzell]

The cell with the below formula returns the #N/A sign.

=VLOOKUP(A3,'!MW'!A:J,5,FALSE)

The value I am looking up (A3 on this occasion) is
sometimes #N/A (which I know)

Is there an IF formula that I can incoroporate within the
above formula to return "" if my lookup value (A3) equals
#N/A. ????

I hope someone follows this!

Thanks in advance!

 

[Peo Sjoblom]

=IF(ISNUMBER(MATCH(A3,'!MW'!A:A,0)),VLOOKUP(A3,'!MW'!A:J,5,FALSE),"")

 

[J.E. McGimpsey]

One way:


=IF(ISNA(MATCH(A3,'MW!A:A,FALSE)),"",VLOOKUP(A3,'MW'!A:J,5,FALSE))

 

[Dan E]

Richard,

If the only time you want the blank is when A3 is #N/A then

=IF(ISNA(A3),"",VLOOKUP(A3,'!MW'!A:J,5,FALSE))

Dan E

 

[Guest]

Cheers people! You are stars!

-----Original Message-----
One way:


=IF(ISNA(MATCH(A3,'MW!A:A,FALSE)),"",VLOOKUP(A3,'MW'! A:J,5,FALSE))



.