Index Match Match between a date range

[Chapster5]

Hi all,

Just want to know if it's possible to do an Index Match Match between a date range?

So what I have is a column with a date start (K2:K54) and a column with a date end (L2:L54) on a worksheet called Data. I have the data I want to return from this range N2:U54.

On this Data worksheet I have account names in columns N1:U1.

On another Worksheet called Summary I have a Cell with the date I want looked up between the dates above (Cell D1). Also an account name in A4:A32, In cell B4 I want to return the value from the range N2:U54 on the Data sheet by looking up the date in the cell D1 on this worksheet and the account name from A4:A32.

I can't get my head how it would test if the current date in D1 is between the date range from columns K and L on the Data sheet.

Hope this hasn't been too confusing to understand I would attach the spreadsheet if I knew how!

Cheers

Nick

 

[AhoyNC]

Maybe something like this.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Change ranges to match your data and drag formula down column.

Excel Workbook
	A	B	C	D
1			Date	7/6/2017
2
3
4	Acct4	Name12
5	Acct5	Name13
6	Acct6	Name14
7	Acct8	Name16
Summary

Excel Workbook
	K	L	M	N	O	P	Q	R	S	T	U
1	Start	End		Acct1	Acct2	Acct3	Acct4	Acct5	Acct6	Acct7	Acct8
2	2/5/2017	6/1/2017		Name1	Name2	Name3	Name4	Name5	Name6	Name7	Name8
3	6/2/2017	8/25/2017		Name9	Name10	Name11	Name12	Name13	Name14	Name15	Name16
4	8/25/2017	12/5/2017		Name17	Name18	Name19	Name20	Name21	Name22	Name23	Name24
5	12/6/2017	1/5/2018		Name25	Name26	Name27	Name28	Name29	Name30	Name31	Name32
6	1/6/2018	2/1/2018		Name33	Name34	Name35	Name36	Name37	Name38	Name39	Name40
Data