comparing two columns

[Richardson]

Hi i'm a beginner at formulas in Excel, i'm looking to compare all the values in Column A versus any and all values in Column B, and return a value of True or False.

[dynamoracing]

=IF(A1="","",IF(COUNTIF(B:B,A1),TRUE,False))

[Richardson]

Thanks Dynamoracing, exactly what i was looking for.