I am brand new to this forum. I want to search through a long list (in one column) of text per row in each cell using a name range of 70 keywords, return these results in an adjacent cell on that rows separated by commas. Below is an example of one row. I have around 15,000 rows of texts and want to return rows only if keywords are found and return as below for all applicable rows. [TABLE="border: 1, cellpadding: 1, width: 300"]
[tr][td]A
[/td][td]B
[/td][/tr][tr][td][TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 500"]
[tr][td]The goal of this project is to optimize the design of an automated welding apparatus for small, thin walled, steel storage tanks.
[/td][td][/td][/tr]
[/TABLE]
goal, project, automated
[/td][/tr]
[/TABLE]
keywords in sheet 2 column A are: project civil engineering goal mechanical electrical automated