Lookup Value in non-delineated column

[mikera]

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.

[FDibbins]

Not exactly sure what reult you want, but maybe you can build on this?
=IFERROR(MATCH(E3,G:G,0),MATCH("*"&E3&"*",G:G,0))
This will pull the row number where a match is found, but looking through your data, there is somethat simply do not have a match

[mikera]

This helps, and yes not all of the values have a match. How would I return a value for the cell in column G, for the row # that's produced by the formula?

[FDibbins]

Perhaps something like this?

=IFERROR(INDEX(G:G,IFERROR(MATCH(E3,G:G,0),MATCH("*"&E3&"*",G:G,0))),"Not Found")

You can change the "Not Found" to whatever you want