Formula Help - Return Value from Lookup Table if Cell is between dates

[Johnny Thunder]

I have a table of dates that return a Fiscal Year value if the cells value is between two dates. Not sure how to accomplish this with a formula. Any help is appreciated.

Formula will need to use Prod Start as the starting position and Prod End as the end date.

Sheet that needs formula Sheet1

Marketing Timing Model v2.5.xlsb
	K	L	M	N
3	Prod Start (P1)	Prod End	Release Date	Fiscal Year of Rel
4	Nov-18	May-19	Nov-19	Formula Here
5	Sep-18	Mar-19	Nov-19	Formula Here
6	Nov-18	Mar-19	Dec-19	Formula Here
7	Nov-18	Feb-19	Feb-20	Formula Here
8	Jun-19	Sep-19	Jun-20	Formula Here
9	Apr-19	Aug-19	Jul-20	Formula Here
Data Entry

Data Table on Sheet "Lookups"

Marketing Timing Model v2.5.xlsb
	F	G	H
3	Prod Start	Prod End	Return Value
4	Oct-17	Sep-18	FY - 2018
5	Oct-18	Sep-19	FY - 2019
6	Oct-19	Sep-20	FY - 2020
7	Oct-20	Sep-21	FY - 2021
8	Oct-21	Sep-22	FY - 2022
9	Oct-22	Sep-23	FY - 2023
10	Oct-23	Sep-24	FY - 2024
11	Oct-24	Sep-25	FY - 2025
12	Oct-25	Sep-26	FY - 2026
13	Oct-26	Sep-27	FY - 2027
14	Oct-27	Sep-28	FY - 2028
Lookups

 

[Special-K99]

So whats your expected output?

 

[Johnny Thunder]

Column H values. From the Lookups Sheet.