Searching Combo Boxes?

[KolbyPanda]

Trying to find a formula to seach a range of combo box cells for a word and display a text in another cell.
Example...

(Combo Box Cells)
A1: John Doe - EMT
A2: Jane Doe - Paramedic
A3: Pizza Dough - EMT

Need a separate Cell, lets say B1 to contain "ALS" for Paramedic or "BLS" if the list doesnt contain the word "Paramedic". The Paramedic text can be in any of the three cells on any given day or not at all.

So far, I was trying in cell B1 =IF(ISNUMBER(SEARCH("*Paramedic*",A1:A3)),"ALS","BLS")

Im not positive that my issue is dealing with combo box results or not. Im sure im wayyyyy off...., Help?

 

[Eric W]

Welcome to the forum.

How about:

=IF(COUNTIF(A1:A3,"*Paramedic*"),"ALS","BLS")

 

[KolbyPanda]

Hours of banging my head..... That simple...


TYTY!! Worked perfectly!

 

[Eric W]

Glad to help!