In Google sheets, I’m trying to lookup the value from column A that when a supplied date is between the values in column B and C. For example, if I were looking for the value when 5/8/2024 is supplied, I would get 35. I did some Googling and I think the FILTER function is the way to go but am not able to get it to work. Can anyone help me see what I am doing incorrectly?

=FILTER('Pay Periods'!A:A,'Pay Periods'!B:B>=A192,'Pay Periods'!C:C<=A192)