Matching function or no match

[Donna]

I am using this formula to compare 2 list to see which numbers are not
included in both column A and Col C. The formula I am using below pulls out
the ones that i do have a match . Is there another function that I could
use that would only pull out the ones that there is not a match?

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
Thanks

 

[Bob Phillips]

Uh

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),A1,"")

 

[Gary''s Student]

Swap them:

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),A1,"")

 

[T. Valko]

Another one...

=IF(COUNTIF(C$1:C$5,A1),"",A1)