Looking up if a cell matches anything a list, where the list are *wildcarded* snipets

Hi,

I've used various sources to answer my excel questions over the years so a preemptive thanks to those that take the time to help others. This is the first time I've need to post for help (probably because it's a hard query to research).

Essentially I've made a finance spreadsheet that takes my bank statement and uses a SUMIFS to total up matching spends. So I have one sheet with the bank statement (date, description, money in, money out, etc), and a second sheet with a list of payment descriptions (which are wildcarded to help them match the bank statement entries) and the SUMIFS column to total them.

When looking at my list of transactions on the bank statement it's hard to be sure I've accounted for them all on the second sheet (list is quite long). Is there a formula that could take the full description of a transaction, then do a lookup on the list with wildcarded names on the second sheet and return if any would match? It's sort of doing a wildcard search in reverse which is why it's hard to research the answer.


Hope that makes sense! I'll mock up a screenshot if it's unclear.

Thanks