Multi-date array lookup

[Samhill62]

Hi Excel gurus,
I have a conundrum I need solving (I have been working on it for at least 48 hours!

On worksheet 1, I have an array which is comprised of multiple columns and rows and each cell in the array is populated with a date. The dates represent dates of bonus payments made to Colleagues. The colleagues names are in the column at the farthest left side.

On worksheet 2, I have a table which has a header row of individual sequential dates and eventually a number of rows beneath.

I would like the table on Worksheet 2 to automatically list all of the names relating to the individuals who have been paid on the date that is in the respective header.
"Easy!" I hear you say, not for this numbskull!! Please help?!?

Many thanks in advance.

Sheet 1:

Sheet 2:

 

[RasGhul]

Hi Sam,

Can you copy & paste some sample data?

 

[Samhill62]

Hi Sam,

Can you copy & paste some sample data?

Hi Ras,

Tried to insert pictures but even that failed. Here is the simplified version:

Array:

Bob	15/01/2019	23/01/2019	31/01/2019	08/02/2019	11/02/2019
Pete	15/01/2019	16/01/2019	23/01/2019
Mike	17/01/2019	31/01/2019	01/02/2019	29/04/2019	30/04/2019
Will	17/01/2019	26/02/2019	29/03/2019	15/04/2019	08/05/2019
Dave	19/01/2019	20/01/2019	04/02/2019	05/02/2019	20/02/2019
Alice	21/01/2019	29/01/2019	06/02/2019
Jane	22/01/2019	04/02/2019	20/02/2019	01/04/2019	25/04/2019
Steve	23/01/2019	31/01/2019	11/02/2019	19/02/2019	07/03/2019
Harry	23/01/2019	31/01/2019	11/02/2019	19/02/2019	20/03/2019

<tbody>
</tbody>

Output (on a different worksheet):

21/01/2019	22/01/2019	23/01/2019	24/01/2019	#######	########
Alice	Jane	Steve	Julian	etc	etc
Ted	Ralph	Harry		etc	etc
Mark		John		etc
				etc

<tbody>
</tbody>

Cheers,

Sam.

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F
1
2	Bob	15/01/2019	23/01/2019	31/01/2019	08/02/2019	11/02/2019
3	Pete	15/01/2019	16/01/2019	23/01/2019
4	Mike	17/01/2019	31/01/2019	01/02/2019	29/04/2019	30/04/2019
5	Will	17/01/2019	26/02/2019	29/03/2019	15/04/2019	08/05/2019
6	Dave	19/01/2019	20/01/2019	04/02/2019	05/02/2019	20/02/2019
7	Alice	21/01/2019	29/01/2019	06/02/2019
8	Jane	22/01/2019	04/02/2019	20/02/2019	01/04/2019	25/04/2019
9	Steve	23/01/2019	31/01/2019	11/02/2019	19/02/2019	07/03/2019
10	Harry	23/01/2019	31/01/2019	11/02/2019	19/02/2019	20/03/2019
Sheet1

Excel 2013/2016
	B	C	D	E	F	G
1	21/01/2019	22/01/2019	23/01/2019	24/01/2019	11/02/2019	25/04/2019
2	Alice	Jane	Bob		Bob	Jane
3			Pete		Steve
4			Steve		Harry
5			Harry
Sheet3

Cell Formulas
Range	Formula
B2	=IFERROR(INDEX(Sheet1!$A$2:$A$10,AGGREGATE(15,6,(ROW(Sheet1!$A$2:$A$10)-ROW(Sheet1!$A$2)+1)/(Sheet1!$B$2:$F$10=B$1),ROWS($A$1:A1))),"")

 

[Samhill62]

Many thanks Fluf, just brill. This is why you are gurus . AGGREGATE- new one on me!

Cheers once again for everyone’s input.

Sam.

 

[Fluff]

You're welcome & thanks for the feedback