Attempting to Organize Spending into Categories

Hello,

As the title states, I am attempting to write a function that will return a category for debits within a bank statement. For example, if the column to the left contains the text "LITTLE CEASARS" I would like it to return "Restaurant", if it contains "AMAZON" I would like it to return "Amazon", etc. I'm sure there's a way to do this but I cannot get it dialed in. Here is what I'm working with so far:

=IF(SEARCH("LITTLE CEASARS",G3),"Restaurant", IF(SEARCH("AMAZON",G3),"Amazon"), "Other")

The first part of that function just searching for "LITTLE CEASARS" would return "Restaurant" correctly, until I added the second IF function. Now excel is just telling me there is a problem with the formula.

Thank you for the help,
Josh

Dave,

Thank you for the reply! That does sound much simpler. I've attempted that function but for some reason it is returning the same thing for all the rows? Any advice on what I've done wrong?

I've tried to attach a screenshot.

Thanks again,
Josh