=IF(A1=B1:B5,true,false) Hey Guys,

I need a formula that will return true or false if cell A1 matches cell B1,B2,B3,B4 or B5.

Is my formula close? Does anyone have any suggestions?

Thank you.

=IF(OR( A1=B1, A1=B2, etc.), TRUE, FALSE)or (better)

=IF(COUNTIF(B1:B5,A1)>0, TRUE, FALSE)

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

=IF(COUNTIF(B1:B5,A1)>0, TRUE, FALSE) Thank you very much this worked perfectly!!!!

Ask Your Question

Weekly Poll