Assign a value based on a date within date ranges

[SeleneExcel]

Hello,

I need to assign a label to data based on the date, which falls within a date range. I organized my dates as follows:

Start	End	Range Label
01/01/21	03/28/21	Aqueduct Winter
04/01/21	04/18/21	Aqueduct Spring
04/22/21	07/11/21	Belmont Spring/Summer
07/15/21	09/06/21	Saratoga
09/16/21	10/31/21	Belmont Fall
11/05/21	12/05/21	Aqueduct Fall
12/09/21	12/31/21	Aqueduct Winter
01/01/22	03/27/22	Aqueduct Winter
03/31/22	04/24/22	Aqueduct Spring
04/28/22	07/10/22	Belmont Spring/Summer
07/14/22	09/05/22	Saratoga
09/15/22	10/30/22	Belmont Fall
11/04/22	12/04/22	Aqueduct Fall
12/08/22	12/31/22	Aqueduct Winter

For example, if I have a pay date ending 3/28/2021, I want it to return to "Aqueduct Winter."

 

[kevin9999]

Something like this maybe?

Book1
	A	B	C
1	Start	End	Range Label
2	01/01/2021	03/28/2021	Aqueduct Winter
3	04/01/2021	04/18/2021	Aqueduct Spring
4	04/22/2021	07/11/2021	Belmont Spring/Summer
5	07/15/2021	09/06/2021	Saratoga
6	09/16/2021	10/31/2021	Belmont Fall
7	11/05/2021	12/05/2021	Aqueduct Fall
8	09/12/2021	12/31/2021	Aqueduct Winter
9	01/01/2022	03/27/2022	Aqueduct Winter
10	03/31/2022	04/24/2022	Aqueduct Spring
11	04/28/2022	07/10/2022	Belmont Spring/Summer
12	07/14/2022	09/05/2022	Saratoga
13	09/15/2022	10/30/2022	Belmont Fall
14	11/04/2022	12/04/2022	Aqueduct Fall
15	12/08/2022	12/31/2022	Aqueduct Winter
16
17	Examples
18	Date 1	03/28/2021	Aqueduct Winter
19	Date 2	10/30/2021	Belmont Fall
20	Date 3	07/12/2022	Date outside all date ranges!
Sheet1

Cell Formulas
Range	Formula
C18:C20	C18	=IFERROR(INDEX($C$2:$C$15,MATCH(1,(B18>=$A$2:$A$15)*(B18<=$B$2:$B$15),0)),"Date outside all date ranges!")

 

[SeleneExcel]

Thank you! It worked great!

 

[kevin9999]

Thank you! It worked great!

Happy to help and thanks for the feedback

 

[SeleneExcel]

Thank you! It worked great!

I tried transposing to my worksheet but it didn't work becasue the data is on one tab, and the Pay Code table, is on a different tab. How can we make it work?

This is the sheet where I have the data (tab name, "Pay Type Hours Earnings"):

And this is the sheet where I have the categories (tab name, "Racing Days"):

 

[kevin9999]

You just need to 'point' the formulas to the tab where the lookup range is, something like this:
Racing Days tab

Book1
	A	B	C
1	Start	End	Range Label
2	01/01/2021	03/28/2021	Aqueduct Winter
3	04/01/2021	04/18/2021	Aqueduct Spring
4	04/22/2021	07/11/2021	Belmont Spring/Summer
5	07/15/2021	09/06/2021	Saratoga
6	09/16/2021	10/31/2021	Belmont Fall
7	11/05/2021	12/05/2021	Aqueduct Fall
8	09/12/2021	12/31/2021	Aqueduct Winter
9	01/01/2022	03/27/2022	Aqueduct Winter
10	03/31/2022	04/24/2022	Aqueduct Spring
11	04/28/2022	07/10/2022	Belmont Spring/Summer
12	07/14/2022	09/05/2022	Saratoga
13	09/15/2022	10/30/2022	Belmont Fall
14	11/04/2022	12/04/2022	Aqueduct Fall
15	12/08/2022	12/31/2022	Aqueduct Winter
Racing Days

Pay Type Hours Earnings tab (partial)

Book1
	N	O	P	Q	R	S	T
1	Pay Ending Date						Meet
2	01/03/2021						Aqueduct Winter
3	07/10/2021						Belmont Spring/Summer
4	08/08/2022						Saratoga
5	07/12/2022						Date outside all date ranges!
Pay Type Hours Earnings

Cell Formulas
Range	Formula
T2:T5	T2	=IFERROR(INDEX('Racing Days'!$C$2:$C$15,MATCH(1,(N2>='Racing Days'!$A$2:$A$15)*(N2<='Racing Days'!$B$2:$B$15),0)),"Date outside all date ranges!")