I need a formula that will look in a cell that contains text and if that
text contains certain words the formula will return a value based on which
text it finds and example will be something like this:

The cell the formula looks at might contain the following:

Walgreens 1234 abc
CVS 5678 def
Target 9012 ghi
Babies R US 3456 jklmno

I need the formula to return a 60 if the cells contains WALGREENS OR CVS
return 120 if the cell contains Target or return 30 if the cell contains
Babies are us.

Any help would be greatly appreciated.

Thanks