Compare two columns of data

[nicole_l]

I am looking for a formula that produces the following please :)

If range of values in column B also appear within range of values in column A, column C = YES or NO

I know this is probably a very basic query and that the answer is out there i just cant work out how to word my question! Hopefully this makes sense.

eg;

A	B	C
1	2	YES
2	8	NO
3	9	NO
4	3	YES
5	7	NO

[#2]

Hi @nicole_l 

Please try below formula:

=IFERROR(IF(MATCH(B2,$A$2:$A$6,0)>0,"Yes","No"),"No")

Sample file is also attached for your reference.

Thanks

Tauqeer

[#3]

@nicole_l 

Hi, assuming your table starts in cell A1, write this formula in Cell C2 and copy down:

=IF(COUNTIF(A:A;B2)=1;"YES";"NO")