Hello all,

I have two sets of values in two columns.

For example, in column A, I have 200 different values, and in column B, I have 150 different values

I am trying to write a formula that checks each value in column B and compares it to ALL values in column A to see if there is a duplicate. I will run this formula against all values in column B which checks each individual B value against all the values in A.

Could someone help me out with this? The only way I could think to do it is:

=IF(B1=OR(A1:A200),"Yes","No")

I am getting a #VALUE error on this one, so I assume the OR statement won't check individually each value from A1 to A200.. Or am I completely backwards?

Thanks for any help that can be provided!