Formula or VBA - assign a new date from a list each time a group of names repeat

[willow1985]

I am creating a spreadsheet that has a list of attendees and a list of meeting dates.

I need a formula or VBA for column B that assigns a meeting date from the meeting date list in column L to a group of Attendees each time the group of attendees repeats.

Any ideas or help with this would be greatly appreciated.

Thank you

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Row #	Date of Meeting	Attendee	Notes	Owner	Action Item	Target Completion Date	Complete Y/N	Actual Completion Date			Meeting Dates		Employee 2
2	2	4-Jan-22	Employee 2					.				6-Jan-22		Employee 3
3	3	4-Jan-22	Employee 3					.				11-Jan-22		Employee 4
4	4	4-Jan-22	Employee 4					.				13-Jan-22		Employee 5
5	5	4-Jan-22	Employee 5					.				18-Jan-22		Employee 6
6	6	4-Jan-22	Employee 6					.				20-Jan-22		Employee 7
7	7	4-Jan-22	Employee 7					.				25-Jan-22		Employee 8
8	8	4-Jan-22	Employee 8					.				27-Jan-22		Visitor
9	9	4-Jan-22	Visitor					.				1-Feb-22		Visitor
10	10	4-Jan-22	Visitor					.				3-Feb-22
11	11	4-Jan-22	Employee 2					.				8-Feb-22
12	12	6-Jan-22	Employee 3					.				10-Feb-22
13	13	6-Jan-22	Employee 4					.				15-Feb-22
14	14	6-Jan-22	Employee 5					.				17-Feb-22
15	15	6-Jan-22	Employee 6					.				22-Feb-22
16	16	6-Jan-22	Employee 7					.				24-Feb-22
17	17	6-Jan-22	Employee 8					.				1-Mar-22
18	18	6-Jan-22	Visitor					.				3-Mar-22
19	19	6-Jan-22	Visitor					.				8-Mar-22
20	20	6-Jan-22	Employee 2					.				10-Mar-22
21	21	6-Jan-22	Employee 3					.				15-Mar-22
22	22	11-Jan-22	Employee 4					.				17-Mar-22
23	23	11-Jan-22	Employee 5					.				22-Mar-22
24	24	11-Jan-22	Employee 6					.				24-Mar-22
25	25	11-Jan-22	Employee 7					.				29-Mar-22
26	26	11-Jan-22	Employee 8					.				31-Mar-22
27	27	11-Jan-22	Visitor					.				5-Apr-22
28	28	11-Jan-22	Visitor					.				7-Apr-22
29												21-Apr-22
30												26-Apr-22
31												28-Apr-22
32												3-May-22
33												5-May-22
34												10-May-22
35												12-May-22
36												17-May-22
37												19-May-22
38												24-May-22
39												26-May-22
40												31-May-22
41												2-Jun-22
42												7-Jun-22
43												9-Jun-22
44												14-Jun-22
45												16-Jun-22
46												21-Jun-22
47												23-Jun-22
48												28-Jun-22
49												30-Jun-22
50												5-Jul-22
51												7-Jul-22
52												12-Jul-22
53												14-Jul-22
54												19-Jul-22
55												21-Jul-22
56												26-Jul-22
57												28-Jul-22
58												2-Aug-22
59												4-Aug-22
60												9-Aug-22
61												11-Aug-22
62												16-Aug-22
63												18-Aug-22
64												23-Aug-22
65												25-Aug-22
66												30-Aug-22
67												1-Sep-22
68												6-Sep-22
69												8-Sep-22
70												13-Sep-22
71												15-Sep-22
72												20-Sep-22
73												22-Sep-22
74												27-Sep-22
75												29-Sep-22
76												4-Oct-22
77												6-Oct-22
78												11-Oct-22
79												13-Oct-22
80												18-Oct-22
81												20-Oct-22
82												25-Oct-22
83												27-Oct-22
84												1-Nov-22
85												3-Nov-22
86												8-Nov-22
87												10-Nov-22
88												15-Nov-22
89												17-Nov-22
90												22-Nov-22
91												24-Nov-22
92												29-Nov-22
93												1-Dec-22
94												6-Dec-22
95												8-Dec-22
96												13-Dec-22
97												15-Dec-22
98												20-Dec-22
99												22-Dec-22
100												27-Dec-22
101												29-Dec-22
RAIL

Cell Formulas
Range	Formula
A2:A28	A2	=ROW()
C2:C28	C2	=IF(ROW()>COUNTA(N:N)*12,"",INDEX(N:N,MOD(ROW()-2,COUNTA(N:N))+1))
H2:H28	H2	=IF(B2<TODAY(),".",IF(B2=TODAY(),"o",IF(B2>TODAY(),"")))

 

[Oaktree]

If it's always the same group of 9 attendees, try something like:

B2 = INDEX(L:L,INT((A2-2)/9)+2)

copied down