Formula needed to: Find/Search for words and copy them into another worksheet (dynamic)

Hi, I'm looking for a formula to search one column (first column, A, in Worksheet 1) for a keyword (just one word) and then paste the results (which the formula automatically updates when that keyword is added/removed from cells in the column) along a Row in another worksheet (Worksheet 3 and Worksheet 4).

The keywords for each formula to reference will be in individual cells in Worksheet 2 in Columns A (for the formula in Worksheet 3) and B (for the formula in Worksheet 4). Hopefully the order of the keywords in Worksheet 2 will match the order in Worksheet 3 so I can just drag the formula down and it references each new keyword.

I have close to zero formula knowledge so please make the solution paint-by-numbers/layman terms, thanks a lot!

Any questions please ask, sample file attached, thanks!

Please read the yellow banner at the top of this page.

Try pasting the following into cell B2 of both the business and personal sheets and then copying down and across:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.