looking up value if provided date falls between two dates
I can't figure this out. I want to be able to type a date into E2 (GREEN) and have F2 (BLUE) return the value $30 (from C5) because that's the value when E2 is between that START DATE and END DATE.
For example, if the user puts 08/13/2024 into E2, F2 would return $50.
What's the formula to put into F2?
Thank you for any help.
Mac Studio (2023)