How Do I Compare one cell to an Entire Column

[ExcelAlex]

Thank you.

That worked great. Now, to make matters worse: I need to compare data
in A1 and B1 to any data in Columns C & D but keeping in mind the 2
data are paired:

Thus-
IF
(Cell in Column 1 and Cell in Column 2) = (Any Cell in Column 3 and
Adjacent Cell in Column 4)
THEN
Column 3 = "TRUE"

I Tried this but it didn't work:
=IF((COUNTIF(C,A1:B1)>0),TRUE,FALSE)


Please advise!
Alex

 

[Myrna Larson]

=SUMPRODUCT(--(A1=C1:C20),--(B1=D120))>0