Help: Trying to boolean search down a column and note matches.

Hi! I have a 10,000s column of data which all fall into 1 of 5 categories but are unmarked so far, I need to mark them 1-5.

I am hoping to find a formula that would work as a boolean search of sorts and when a match is found it would copy a 1-5 depending on the category of search.


The A column looks something like this:

cat food
cat food
dog food
human food
pool rental
car rental
boat rental

When I run the formula which searched for "+food -human" it would result in writing a 1 in the adjacent column which is coded to mean pet food but not the "human food" cell.

Any help is greatly appreciated. Thanks!