In worksheet 1: I have a fairly short list (~75) of values (text strings) and would like to find all matches of these strings with values from a column in another worksheet (worksheet 2)... these values might exist anywhere within a much longer string/passage in that known column.
Further, I'd like to be able generate a third worksheet with rows equal to the matched values... building a row for each, but also containing some of the other columns from worksheet 2.
ABC DEF GHI ... XYZ
Column1 Column2 Column3 blah1 blahA Chemical DEF is a compound blah2 blahB Compound 24231 (also known as GHI)...
Col1 Col2 Col3 DEF blah1 blahA GHI blah2 blahB
Can this be done with Excel?