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

The "Front" worksheet
	A	B	C	D
1	Org.	Next Event	2nd Future Event Date	3rd Future EventDate
2	ABC	1/26/18	1/29/18	1/29/18
3	Description of event: from event worksheet
4
5	TDS	2/21/18	3/14/18	3/21/18
6	Description of event:
7
The "Event" Worksheet
	A	B	C	D	E	F
1	Org	Date	Time	Location	Address	Comments
2	ABC	1/23/2018	8:30AM	Skating Rink	123 Turnaround Lane	Skating
3	ABC	1/25/2018	8:30AM	Library	124 Read Ave	Reading Lab
4	ABC	1/26/2018	8:30AM	Movie Theatre	524 Watching Road	Movie
5	ABC	1/29/2018	9:30AM	Skating Rink	123 Turnaround Lane	Skating
6	ABC	1/29/2018	1:30PM	Mall	435 Buy Blvd	Mall Event
7	ABC	1/30/2018	8:30AM	Library	124 Read Ave	Reading Lab
8	ABC	2/1/2018	8:30AM	School	2010 Learning Ave	School Tutor Program
9	ABC	2/2/2018	8:30AM	Pottery Studio	875 Molding Way	Pottery Workshop
10	ABC	2/5/2018	9:30AM	Movie Theatre	524 Watching Road	Movie
11	ABC	2/5/2018	1:30PM	Library	124 Read Ave	Reading Lab
12	ABC	2/6/2018	8:30AM	School	2010 Learning Ave	School Tutor Program
13	ABC	2/8/2018	8:30AM	Pottery Studio	875 Molding Way	Pottery Workshop
14	TDS	1/10/2018	9:00 AM	YMCA	321 Get Fit	Afterschool Party
15	TDS	1/17/2018	9:00 AM	School	125 Show Ave	School Dance
16	TDS	2/14/2018	9:00 AM	Big Brothers	125 Donation Way	Fundraiser
17	TDS	2/21/2018	9:00 AM	Library	124 Read Ave	Book Drive
18	TDS	3/14/2018	9:00 AM	YMCA	321 Get Fit	Special Olympics Event

<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>
</tbody>

 

[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!!!!