Extract multiple matches into separate rows

[RKROX907]

Good Day everyone,

I'm trying to pull date from C:C by matching against the value in B2.
The current

 =INDEX(C:C,MATCH("*"&B2&"*",C:C,0))

formula that i build can only pull & extract one match.
How can i pull multiples matches and extract them as shown on Columns H,I and J

 

[Eric W]

Welcome to the forum.

Try:

	A	B	C	D	E	F	G	H	I	J	K
1		SKU	URL				SKU
2		Product1	URL/Product1/1.IMG				Product1	URL/Product1/1.IMG	URL/Product1/2.img	URL/Product1/3.img
3		Product2	URL/Product1/2.img				Product2	URL/Product2/1.IMG	URL/Product2/2.IMG	URL/Product2/3.IMT
4		Product3	URL/Product1/3.img
5			URL/Product2/1.IMG
6			URL/Product2/2.IMG
7			URL/Product2/3.IMT
8

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Array Formulas Cell Formula H2 {=IF($G2="","",IFERROR(INDEX($C$2:$C$10,SMALL(IF(ISNUMBER(SEARCH($G2,$C$2:$C$10)),ROW($B$2:$B$10)-ROW($B$2)+1),COLUMNS($H2:H2))),""))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

The formula in H2 is an array formula. Enter it in the formula bar, change the ranges to match your sheet, then press Control+Shift+Enter, not just enter. Then drag down and to the right as needed.

Hope this helps.

 

[RKROX907]

Thanks a lot. I End-up using a different method.
I use concatenation to concatenate the URL & Product name