I have a column with values that contain specific keywords I want to check for and create some "IF" statements based on whether it can find a match.

For example:

Column B contains the text string: Payment to Wal-Mart
and I would search for "Wal-Mart" and return the text "Grocery" in column C.

How?