Find all instances of a word in sheet and input target word in same row different column

Hi All, Im new here and have basic excel knowledge. My accountant emailed me over a spreadsheet of book keeping items broken up into columns: Date, Description, Amount, and Type. He wants me to identify what Type each item is such as Small Tools, Gas, Meals, Equipment, etc

There are so many recurring items such as "Shell" in the Description column which is for Type "Gas" that there must be a way to do this quickly instead of going line item by line item and typing "Gas". I am familiar with the Find and Replace but that only finds all "Shell" and replaces it with "Gas".

I want to find all "Shell" in the Description Column and have excel put in "Gas" in the Type Column that corresponds to each line item row.

any help would be much appreciated.

mehmetcik, thanks for responding

I input the formula in the target column but nothing happened

I highlighted the G Column. Then in the formula I typed =IF(ISERROR(FIND("WAWA",LOWER(C3))),"","Gas"). Nothing happened

I thought that the find function was case sensitive that is why I typed it like that.

I change it to wawa and that worked.

Now the problem is when I want to find all "Home Depot" =IF(ISERROR(FIND("home depot",LOWER(C5))),"","repair maintenance"), It deletes all the "Gas" that were put in from the first formula.

I need to be able to have excel not delete items that I have put in "Gas" "Repair Maintenance" "Shop Supplies" and so on until every transaction is marked up