Matching function or no match
 

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

Matching function or no match
 

Uh

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


--

HTH

Bob

"Donna" wrote in message
...

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

Matching function or no match
 

Swap them:

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),A1,"")
--
Gary''s Student - gsnu201001


"Donna" wrote:


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

Matching function or no match
 

Another one...

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

--
Biff
Microsoft Excel MVP


"Donna" wrote in message
...

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