If/Then

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Formula solution in helper column. Or, a macro that just leaves the answer?
=IF(COUNTIF($N$2:$N$22,M2),"Match","")
 
Back
Top