Lookupvalue in table and reference table array for a new value

[CGJoel]

Hello, 

I was hoping someone could assist me in figuring out a way to create a new column of pre-determined group names.

1. TABLE1: List of reviews of people using multiple words to describe their experience

2. TABLE2: List of review groups and multiple words underneath

I would like to create a new column in TABLE1 that creates a "review group" 

- it would search for keywords in TABLE1 ColumnA for a reference table in TABLE2 either columns and depending on the keywords, the new column will state "Positive" or "Negative"

Is that a possibility?

J.