Verify if cell does and does not contain a specific word

[jomilo]

Excel Gurus,

I have a dropdown list in cell A1 with four possible choices:
Statement 1: "50 gallons - White"
Statement 2: "50 gallons - Black"
Statement 3: "25 gallons - Green"
Statement 4: "25 gallons - Blue"

In cell B1 I need to evaluate what was choosen in cell A1 to determine what action to take.

So, how do I tell cell B1 "if A1 does contain the word/number "25" AND does NOT contain the word "Blue" then make B1 equal to cell C1?"

I can get this to work to verify if the cell contains a specific word, but I can't figure out how to combine the AND statement with the ISNUMBER, SEARCH, and NOT statements to also verify if the same cell does NOT contain a certain word. Any help would be greatly appreciated.

Thanks, jomilo

 

[jomilo]

#NAME?,

I'm an idiot.

You're right!!! It does work!!!!

I typed some information in wrong and posted back before I checked my typing more thouroughly.

Thank you so much, and I apologize for any extra work I may have caused you as a result of my lack of typing/communication skills.

Sincerely,

jomilo

 

[T. Valko]

#NAME?,

I'm an idiot.

You're right!!! It does work!!!!

I typed some information in wrong and posted back before I checked my typing more thouroughly.

Thank you so much, and I apologize for any extra work I may have caused you as a result of my lack of typing/communication skills.

Sincerely,

jomilo

No problem! Thanks for the feedback!