=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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History