Search for keyword in table and output all matches

[Mccream1]

Dear Excel-Gurus,

I am facing the problem that I have an Excel-table with a lot of websites in a column. I would like to search through these websites looking for matching keywords and if there is any fit to the keyword, I would like to extract the whole matching row to another place.

The list is quite long and takes quite a while if done single handedly.

I attached a practical use case and the desired outcome to this posting.

Your help is highly appreciated !

Regards

[tim201110]

=iferror(small(if(isnumber(search($a$13,$a$2:$a$8)),row($a$2:$a$8)),rows($a$16:$a16)),"") cse
=index(a:a,$o16)

[MarvinP]

Hi Mccream1,

You can also do your problem using an Advanced Filter and using wildcard searches. If you use *casino* as your filter criteria it would do what you want.

Look at this site and down to the "asterisk" example.

https://trumpexcel.com/excel-advanced-filter/

[Mccream1]

Thank you guys. The Advanced Filter method worked for me.

The only downside is, that the output has to be in the same tab, which does not look very nice when you have a very large table + to keep your tabs clear.

Works anyway ! Thank you everybody!!