Returning the unique label whether a date falls within a list of date ranges that have all been uniquely labeled.

[drmurph]

Hoping someone can help me with this problem I have been having.
I am trying to check whether a date falls within a list of date ranges, and if so, the formula would return the value that has been assigned to the specific date range that the entered date falls within.
In my file, on tab 1 a table has been created labeled, Table2, and has the following data. As you can see, each date range has been assigned a unique #.

Table2;

Period Start Date (Column 1)	Period End Date (column 2)	Assigned Period # (Column 3)
3/9/2020​	9/10/2020	1
9/11/2020​	9/10/2021	2
9/11/2021​	9/30/2021	3
12/8/2022​	12/7/2023	4

On the second tab I have the table where one of the columns is a list of the dates I want to check and a column for the Assigned Period # that that date falls within.
Table5;

Entered Date (Column E)	Assigned Period # (Column I)
3/13/2020 0:00​
3/17/2020 0:00​
3/17/2020 0:00​
3/17/2020 0:00​
3/23/2020 0:00​

 

[drmurph]

I was able to solve this problem with the use of another article

 

[drmurph]

if it matters to anyone what the solution was, here ya go
=IFERROR(INDEX(Table2[ASSIGNED PERIOD #],MATCH(1, ([@ENTERED DATE]>=Table2[Period Start Date])*([@ENTERED DATE]<=Table2[Period End Date]),0)),"DATE not within any Period")