Search Google Sheet column for matching text and print matches
<p>I have a table with Long Words like 'Condemnation' and 'Income' in column A, and Shorter Words such as 'Con' and 'Come' in column B.</p>

<p>I'd like to create a cell to the right which will search through the 'LONG WORD' column if it contains the text of the 'SHORTER WORD' column and print them as a pair.</p>

<p>I only need it to return the first instance it comes across as it goes down.</p>

<p>I have looked at various MATCH and LOOKUP commands, but none seem quite to be able to do the 'return one matching word from a whole column' bit.</p>

<p>Thanks</p>

<p>Tardy</p>