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.

mwf

Recipe1

monday

m

m

t

w

r

f

s

n

trs

recipe 2

tuesday

t

?

?

?

?

?

?

?

mw

recipe 3

wednesday

w

sn

recipe 4

thursday

r

trsn

recipe 5

friday

f

saturday

s

sunday

n

<tbody>
</tbody>

 

[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