Index/Match Array with multiple results concatenate in one cell

Hi,

This is my first time ever posting on a forum so apologies in advance if i make mistakes.

I'm using Microsoft Excel for Mac 2011

This is my Data:

	A	B	C
1	ARTIST	DATE	SHOT
2	Ben	1-Jan	101
3	Jerry	2-Jan	102
4	John	1-Jan	103
5	John	4-Jan	104
6	John	1-Jan	105

I would like the results to be like this:

	D	E	F
1	FIND Artist	FIND Date	Shots Scheduled
2	John	1-Jan	103 105

I'm looking for a formula that will search for "Artist" and "Date" and then if they match return all the shots found within one cell, preferably each shot on a seperate line but still within the one cell.

Is this possible?

I searched the forums and found this formula works but only returns the first result that it finds.
=INDEX($C$2:$C$6,MATCH(D2&E2,$A$2:$A$6&$B$2:$B$6,0))

Is there a UDF that can use this array to combine all the results in one cell?

Let me know if you need more information,
Thanks for your time I've been really struggling with this

Im happy you were able to resolve your question yourself, and thanks for sharing that with us

I will mark the thread SOLVED for you, but for future reference, you can mark them solved like this...
on your 1st thread, click "Edit Post"
click "Go Advanced"
on the "Prefix" drop-down, select SOLVED
click saved