If/Then
 

I have two sets of numbers I would like to check against eachother for matches.

I would like to paste a group of numbers and have a formula tell me if any
of the numbers match the master list.
Master List Test list desired outcome
1 2 (match) or YES
2 456 (match)
3 7 (no match) or NO
456 9 (no match)
54 53 (no match)
34 65 ...etc
32 3
45 98
36 57

If/Then
 

With your two lists in columns A & B , then in column C

C2: =IF(COUNTIF($A$2:$A$100,B2),"Matched","No match")

copy down to end of column B list

Change A range as required

"Thank you, Heath" wrote:

I have two sets of numbers I would like to check against eachother for matches.

I would like to paste a group of numbers and have a formula tell me if any
of the numbers match the master list.
Master List Test list desired outcome
1 2 (match) or YES
2 456 (match)
3 7 (no match) or NO
456 9 (no match)
54 53 (no match)
34 65 ...etc
32 3
45 98
36 57

If/Then
 

Formula solution in helper column. Or, a macro that just leaves the answer?
=IF(COUNTIF($N$2:$N$22,M2),"Match","")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Thank you, Heath" wrote in
message ...
I have two sets of numbers I would like to check against eachother for
matches.

I would like to paste a group of numbers and have a formula tell me if any
of the numbers match the master list.
Master List Test list desired outcome
1 2 (match) or YES
2 456 (match)
3 7 (no match) or NO
456 9 (no match)
54 53 (no match)
34 65 ...etc
32 3
45 98
36 57