Look Value in another column

[silvertabb]

I have data in column A and B. In column C I need to enter a formula to help see whether or not data in Column B is repeated in Column A. Here is what I have in mind:

1) Is B1 contained in A1:A100 range?
2) If the answre is Yes the output should be YES otherwise it should generate NO
3) Reapeat 1 and 2 for the remaining entries in Column B

thanks,
Said

Would this work:

=if(iserror(vlookup(B1,A1:A100,1,F)),"Yes","NO")

 

[JackDanIce]

Try:

=IF(ISNUMBER(MATCH(B1,$A$1:$A$100,0)),"Yes","No")

Drag down for rest of your values in the B column

 

[Trebor76]

n/a

 

[Trebor76]

Hi silvertabb,

Put this formula ...

=IF(COUNTIF($A$1:$A$100,B1)>0,"Yes","No")

..in cell C1 and then copy down to cell C100

HTH

Robert

 

[JackDanIce]

n/a (as above!)