In excel I have two sheets. In Sheet1 Column A, I have strings. In Sheet2 I have two columns, Column A contains one word that should potentially be somewhere in a string from Sheet1, and Column B has a return value that I would want if Sheet2!A:A was found anywhere in the strings in Sheet1!A:A. For Example:
Sheet 1:
Col. A **Col. B (These are the results I WANT from Sheet2)**
stackoverflow excel blue pony Group2
grapes monkey help me Group1
random words not very creative Group3
And in Sheet 2, you have
Col. A Col. B
monkey Group1
excel Group2
creative Group3
I have been messing around with what basically comes down to a bunch of different iterations of a vlookup for Sheet1!B:B, but I can never get it to work right. The reason I have been focusing on vlookups is because of the need to return the value in Sheet2!B:B if Sheet2!A:A if found anywhere in Sheet1!A:A. I'm sure there is probably something much better out there for this solution than that, I am just stuck on this. Any help would be greatly appreciated.