Hello guy i am trying to come up with a formula but i have no idea how i need
some help from the experts.

I have two columns,
1 contains information and the other one is empty where the formula is going
to be called "product type"

So what i need is:

If column A contains the word: Apple, strawberry, banana. Column B should
be = Fruits

If column A contains: tomatoe, carrot, onion B = Vegetable

If columb A contains anything other than: Apple, strawberry, banana,tomatoe,
carrot, onion. B= Beef

Is it possible to create this formula?

Thanks