Partial matching to multiple cells

Hello all,

Please see the attached image below. I am having trouble with partial matching & joining together results.

As you can see, I have recipes 1-5 in column B, with corresponding days of the week in column A beside them. The letters in column A correspond to days of the week. For instance, when doing a partial match for symbol "m", it yields one result, and that is Recipe 1. However, there is also an "m" that corresponds with Recipe 3. What function might I use to perform a partial search with multiple results.

My follow up question is that if you are able to retrieve the appropriate recipes for each symbol, could you then join the results using a joint text function and place it in the proper location in the table. Example: Underneath symbol "m" in the table, this would yield "Recipe 1 & Recipe 3"

Thank you for your help.










forum.png

Wow. You sir, are a serious game changer!!! This worked!! Thank you very much for being kind enough to help me out. That solves a major problem that I was trying to figure out for many hours!

With much gratitude,
David

Hey Bo!

Thanks so much for your reply a few days ago.
I encountered a problem that somewhat builds off of my last question that you may be interested in.
If you have any desire to check it out, it is called "Combining two find functions" under the excel formulas & functions thread. Unfortunately, it looks like it is not allowing me to directly paste the link here .

Thanks!