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