lookup formula

[warhorse927]

Two questions O guru's of computational,conversional,conversational spreadsheets!

If I have a 14 X 8 table filled with DATES. How do I display the date(s) that are between two dates? For instance between the dates 9/1/02 and 9/13/02 there are 3 dates on three different rows. Once finding those dates how can I get it to display the colunm head? TIA in humble humility (or should that be futility?)

 

[warhorse927]

AquinasPTforcast.xls
	D	E	F	G	H	I	J
1		ABA
2		BSBA		Beg.Date	9/1/02
3		SharedbyBSBA&MIS		EndDate	9/20/02
4		BSMIS
5
6
7	Course	CourseTitle			#ofstudents	Cohort(s)	Date
8	ACC101	AccountingforBusiness			8
9	ACC201	Prin.ofAccountingI			0
10	ACC331	ManagerialAccounting			7
11	BIO210	EnvironmentalStudies			0
12	BUS140	BusinessMath			0
13	BUS145	Math.SolutionstoBusiness			13
14	BUS205	ProfessionalCommunications			0
15	BUS210	Statistics			0
16	BUS212	QuantitativeMethodsI			0
17	BUS240	Indust.Organ.Behavior			15
18	BUS250	FinancialMarketsforBusiness			0
19	BUS260	CurrentLegalIssues			0
20	BUS295	BusinessCaseStudies			0
21	BUS310	Prod./Oper.Management			12
22	BUS345	FinancialManagement			0
23	BUS459	ManagementofH.R.			0
24	BUS476	BusinessEthics			8
25	BUS495	StrategicMngt.Analysis			0
26	ECO101	Prin.OfEconomics(Micro)			0
27	ECO301	ManagerialEconomics			0
28	ENG111	EnglishCompositionI			15
Class by course number

Paddy,

this is the output I am trying to get from the table in my earlier post. I tried a variation of my formula to get the cohort but it returns 0 in all but two cells which do return the correct cohort. Why is that? One cell works as a regular formula but the other one works as a CSE?
Mike

 

[warhorse927]

Here is the sheet that actually contains the formulas. As you can see some classes are in more than one program so I summed them on the other page.

 

[warhorse927]

AquinasPTforcast.xls
	A	B	C	D	E
1				Beg.Date	9/1/02
2				EndDate	9/20/02
3			Course
4	ABA	1	IDS105		0
5		2	MGT230		15
6		3	ENG111		15
7		4	BUS240		15
8		5	FAR220		15
9		6	HIS202		13
10		7	BUS145		13
11		8	ENG112		13
12		9	MGT250		26
13		10	BIO210		0
14		11	PHI211		12
15		12	ENG330		0
16		13	THE115		11
17		14	BUS260		0
18		15	BUS250		0
19		16	ECO101		0
20		17	MKT120		6
21		18	MIS140		0
22		19	ACC101		8
23		20	MGT204		12
24		21	BUS295		0
25	BSBA	22	IDS345		0
26		23	MGT201		0
27		24	MIS310		0
28		25	MKT220		0
29		26	BUS140		0
30		27	BUS205		0
Class by Program

That's better. I could live with this as the only output. I just need the cohort(s) to display next to the number of students.