Lookup Value in non-delineated column

I'm having issues looking up a set value in a column that has multiple values in it. I've tried index/matching, lookup, vlookup(TRUE) and none return the actual matching value. I even tried offset, but the return value is too inconsistent in the row deviation.

In column 'E' you'll find the value that I'm attempting to match in column 'G', to produce a result in Column 'S' (same row as column 'G''s value). Pretty straight forward but I'm having difficulty matching in column G. Any help would be much appreciated.