Partial matching to multiple cells

[dsteele111]

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.

[TABLE="width: 400"]
<tbody>[TR]
[TD]mwf[/TD]
[TD]Recipe1[/TD]
[TD][/TD]
[TD]monday[/TD]
[TD]m[/TD]
[TD][/TD]
[TD]m[/TD]
[TD]t[/TD]
[TD]w[/TD]
[TD]r[/TD]
[TD]f[/TD]
[TD]s[/TD]
[TD]n[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]trs[/TD]
[TD]recipe 2[/TD]
[TD][/TD]
[TD]tuesday[/TD]
[TD]t[/TD]
[TD][/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]mw[/TD]
[TD]recipe 3[/TD]
[TD][/TD]
[TD]wednesday[/TD]
[TD]w[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sn[/TD]
[TD]recipe 4[/TD]
[TD][/TD]
[TD]thursday[/TD]
[TD]r[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]trsn[/TD]
[TD]recipe 5[/TD]
[TD][/TD]
[TD]friday[/TD]
[TD]f[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]saturday[/TD]
[TD]s[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]sunday[/TD]
[TD]n[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L
1						m	t	w	r	f	s	n
2	mwf	Recipe1	monday	m		Recipe1	recipe 2	Recipe1	recipe 2	Recipe1	recipe 2	recipe 4
3	trs	recipe 2	tuesday	t		recipe 3	recipe 5	recipe 3	recipe 5		recipe 4	recipe 5
4	mw	recipe 3	wednesday	w							recipe 5
5	sn	recipe 4	thursday	r
6	trsn	recipe 5	friday	f
7			saturday	s
8			sunday	n
Sheet1

Cell Formulas
Range	Formula
F2	{=IFERROR(INDEX($B$2:$B$6,SMALL(IF(ISNUMBER(FIND(F$1,$A$2:$A$6)),ROW($A$2:$A$6)-ROW($A$2)+1),ROWS($1:1))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Named Ranges
Name	Refers To	Cells
all	=Sheet2!$B$1:$B$8,Sheet2!$D$1:$D$8,Sheet2!$F$1:$F$8

Fill formula down & across