Comparing columns and copying contents

Hope everyone's weekend went well - -

This shouldn't be too hard,

Looking for a formula that will compare two columns, and in the one's that have matching text strings (not always the entire cell contents) copy the row contents of one column.

TIA

If you want help then please change your title as per forum rules below

VBA Noob

See if link helps

http://www.cpearson.com/excel/ListFunctions.aspx


or a formula like

=IF(COUNTIF(A1,"*"&$B$1&"*")>=1,A1,"")

Where B1 is the text to search in Col A

VBA Noob