Formula to obtain 2nd and 3rd future date from another worksheet

[woodie]

I have two worksheets in my workbook. Sheet 1 is called Front and sheet 2 is called Details. Cells A5-A57 contain events and Cells B5-57 contains the next date of the event in Column A. Column B gets the data from the Details Sheet. The formula I used to get the date of the next (future) event is {=MIN(IF(Details!B2:B283>=TODAY(),Details!B2:B283))}

I now would like to not only have the next event listed on the Front sheet, but the next 3 meetings listed. In Column C I would like the 2nd future meeting and in Column D the 3 future meeting.

As the year progresses, the data on the Front sheet will change to reflect the next 3 upcoming events.

Any assistance anyone could provide will greatly be appreciated.

Woodie

 

[woodie]

thanks so much for all of your help.

 

[woodie]

ok, now I want to list the type of event (from the Event spreadsheet, Column F) under the nextevent date, the 2nd future date and 3rd future date in cells B3, C3 and D3 ofthe
front sheet

[TABLE="width: 616"]
<colgroup><col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1396;"> <col width="167" style="width: 125pt; mso-width-source: userset; mso-width-alt: 5818;"> <col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3258;"> <col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3304;"> <col width="139" style="width: 105pt; mso-width-source: userset; mso-width-alt: 4864;"> <col width="141" style="width: 106pt; mso-width-source: userset; mso-width-alt: 4933;"> <col width="145" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5073;"> <tbody>[TR]
[TD="class: xl94, width: 534, bgcolor: transparent, colspan: 5"]The "Front" worksheet[/TD]
[TD="width: 141, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="class: xl92, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: #FFF2CC"] [/TD]
[TD="class: xl100, bgcolor: #FFF2CC"]A [/TD]
[TD="class: xl101, bgcolor: #FFF2CC"]B[/TD]
[TD="class: xl100, bgcolor: #FFF2CC"]C[/TD]
[TD="class: xl100, bgcolor: #FFF2CC"]D[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: #FFF2CC"]1[/TD]
[TD="class: xl66, width: 167, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Org.[/TD]
[TD="class: xl67, width: 93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Next Event[/TD]
[TD="class: xl66, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]2nd Future Event Date[/TD]
[TD="class: xl66, width: 139, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]3rd Future EventDate[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: #FFF2CC"]2[/TD]
[TD="class: xl86, width: 167, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl87, width: 93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]1/26/18[/TD]
[TD="class: xl87, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]1/29/18[/TD]
[TD="class: xl87, width: 139, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]1/29/18[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: #FFF2CC"]3[/TD]
[TD="class: xl88, width: 167, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Description of event: from event worksheet[/TD]
[TD="class: xl85, width: 93, bgcolor: #FFF2CC"] [/TD]
[TD="class: xl85, width: 95, bgcolor: #FFF2CC"] [/TD]
[TD="class: xl85, width: 139, bgcolor: #FFF2CC"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: #FFF2CC"]4[/TD]
[TD="class: xl68, width: 167, bgcolor: white"] [/TD]
[TD="class: xl69, width: 93, bgcolor: white"] [/TD]
[TD="class: xl69, width: 95, bgcolor: white"] [/TD]
[TD="class: xl69, width: 139, bgcolor: white"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: #FFF2CC"]5[/TD]
[TD="class: xl66, width: 167, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]TDS[/TD]
[TD="class: xl67, width: 93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]2/21/18[/TD]
[TD="class: xl67, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]3/14/18[/TD]
[TD="class: xl67, width: 139, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]3/21/18[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: #FFF2CC"]6[/TD]
[TD="class: xl66, width: 167, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Description of event:[/TD]
[TD="class: xl67, width: 93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "] [/TD]
[TD="class: xl67, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "] [/TD]
[TD="class: xl67, width: 139, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, bgcolor: #FFF2CC"]7[/TD]
[TD="class: xl83, width: 167, bgcolor: white"] [/TD]
[TD="class: xl84, width: 93, bgcolor: white"] [/TD]
[TD="class: xl84, width: 95, bgcolor: white"] [/TD]
[TD="class: xl84, width: 139, bgcolor: white"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl91, bgcolor: white"] [/TD]
[TD="class: xl89, width: 167, bgcolor: white"] [/TD]
[TD="class: xl90, width: 93, bgcolor: white"] [/TD]
[TD="class: xl90, width: 95, bgcolor: white"] [/TD]
[TD="class: xl90, width: 139, bgcolor: white"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl93, bgcolor: white, colspan: 6"]The "Event" Worksheet[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl99, bgcolor: white"] [/TD]
[TD="class: xl103, bgcolor: white"]A[/TD]
[TD="class: xl103, bgcolor: white"]B[/TD]
[TD="class: xl103, bgcolor: white"]C[/TD]
[TD="class: xl103, bgcolor: white"]D[/TD]
[TD="class: xl103, bgcolor: white"]E[/TD]
[TD="class: xl103, bgcolor: white"]F[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]1[/TD]
[TD="class: xl96, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Org[/TD]
[TD="class: xl96, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Date[/TD]
[TD="class: xl97, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Time[/TD]
[TD="class: xl98, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Location[/TD]
[TD="class: xl98, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Address[/TD]
[TD="class: xl98, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Comments[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]2[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]1/23/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]8:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Skating Rink[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]123 Turnaround Lane[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Skating[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]3[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]1/25/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]8:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Library[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]124 Read Ave[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Reading Lab[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]4[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]1/26/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]8:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Movie Theatre[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]524 Watching Road[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Movie[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]5[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl74, width: 93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]1/29/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]9:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Skating Rink[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]123 Turnaround Lane[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Skating[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]6[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl74, width: 93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]1/29/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]1:30PM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Mall[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]435 Buy Blvd[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Mall Event[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]7[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]1/30/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]8:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Library[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]124 Read Ave[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Reading Lab[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]8[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]2/1/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]8:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]School[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]2010 Learning Ave[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]School Tutor Program[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]9[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]2/2/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]8:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Pottery Studio[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]875 Molding Way[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Pottery Workshop[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]10[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl74, width: 93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]2/5/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]9:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Movie Theatre[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]524 Watching Road[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Movie[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]11[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl74, width: 93, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]2/5/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]1:30PM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Library[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]124 Read Ave[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Reading Lab[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]12[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]2/6/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]8:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]School[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]2010 Learning Ave[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]School Tutor Program[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]13[/TD]
[TD="class: xl70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]ABC[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: right"]2/8/2018[/TD]
[TD="class: xl72, width: 95, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]8:30AM[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Pottery Studio[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]875 Molding Way[/TD]
[TD="class: xl73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] "]Pottery Workshop[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]14[/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]TDS[/TD]
[TD="class: xl76, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"]1/10/2018[/TD]
[TD="class: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]9:00 AM[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]YMCA[/TD]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]321 Get Fit [/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Afterschool Party[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]15[/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]TDS[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"]1/17/2018[/TD]
[TD="class: xl81, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]9:00 AM[/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]School[/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]125 Show Ave[/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]School Dance[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]16[/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]TDS[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"]2/14/2018[/TD]
[TD="class: xl81, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]9:00 AM[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Big Brothers[/TD]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]125 Donation Way[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Fundraiser[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]17[/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]TDS[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"]2/21/2018[/TD]
[TD="class: xl81, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]9:00 AM[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Library[/TD]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]124 Read Ave[/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Book Drive[/TD]
[/TR]
[TR]
[TD="class: xl102, bgcolor: transparent"]18[/TD]
[TD="class: xl75, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]TDS[/TD]
[TD="class: xl80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"]3/14/2018[/TD]
[TD="class: xl81, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]9:00 AM[/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]YMCA[/TD]
[TD="class: xl79, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]321 Get Fit [/TD]
[TD="class: xl78, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Special Olympics Event[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

This?

Excel 2010
	A	B	C	D
1	Org.	Next Event	2nd Future Event Date	3rd Future EventDate
2	ABC	1/25/2018	1/26/2018	1/29/2018
3	Description of event: from event worksheet	Reading Lab	Movie	Skating
4
5	TDS	2/14/2018	2/21/2018	3/14/2018
6	Description of event:	Fundraiser	Book Drive	Special Olympics Event
Front

Cell Formulas
Range	Formula
B2	{=SMALL(IF(Event!$A$2:$A$18=Front!$A2,IF(Event!$B$2:$B$18>=TODAY(),Event!$B$2:$B$18)),COLUMN(A1))}
B3	{=INDEX(Event!$F$1:$F$18,SMALL(IF(Event!$A$2:$A$18=Front!$A2,IF(Event!$B$2:$B$18>=TODAY(),ROW(Event!$B$2:$B$18))),COLUMN(A1)))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[woodie]

Thanks so much. It worked perfect for cell B2, however when I tried to drag the formula to the right, I received a #NUM !

 

[woodie]

I tried it again today and it worked perfectly. Thanks so much for all of your help!!!!