Need formula to find partial string match in a separate column and return adjacent value.

Originally Posted by Glenn Kennedy

Your description and your file do not match. The multiple occurrences of the same words all over makes this very confusing. What do you expect to see? Where do you expect to see it? Please read the yellow banner at the top of the page and add some manually calculate dresults.

I understand. Thank you. I've edited my original post and included a new file and thorough description about what I'm trying to achieve and w/ context.