IF statement not working because of dropdown

Hello,

I am looking for a formula for the foll:

Cells A1:A10 contain names, which are in dropdown.

I am looking for a formula which searches if a particular word say 'EXCELL' is in any of the cells A1:A10 and if present in any place within cells A1:A10 to place the info contained in cell B1 and if not place the info in cell B2.

I have tried the below

=IF(OR($A$1"EXCELL",$A$2"EXCELL",),(B1),(B2))... but this I have its extended to $A$10.

This works if I manually type in cells A1-A10, but does not when cells A1-A10 are in the form of a drop down.

Thanks.

Try:

=IF(COUNTIF(A1:A10,"EXCELL)>0,B1,B2)

Slight typo in NBVC's (as always) excellent answer =IF(COUNTIF(A1:A10,"EXCELL")>0,B1,B2)

Thanks for the catch Pecoflyer .