Vlookup and return the entire row(s) based on multiple texts

[EthanK]

Hello guys! I've been unable to resolve this issue for about 12 hours now, so thought I would ask experts for some help.

I have a list of transactions with date, description and amount that I copied/pasted from my PNC bank and I would like to lookup the descriptions and return the rows containing specific keywords (I have a list of keywords).

I have attached an example spreadsheet, the copied/pasted list is in the Consolidated List 2017 sheet and the Taxable Expenses 2017 sheet should automatically extract and return rows containing keywords in the list (on the right in Consolidated List 2017 sheet)

Your help would be tremendously appreciated! Thanks so much