Find a cell in a range with a maximum value that does not exceed a given criterion?

Question

excel

Hello, I'm interested in the possibility of searching for a value in a range by a criterion.
There is a range of rates, for example:

Дата            Тариф
01.01.2021      4.61
04.02.2021      4.68
02.03.2021      4.52
07.04.2021      4.80
03.05.2021      4.92
02.06.2021      4.98

Let's say I have a date - March 25th.
Is it possible, without macros , only with the help of formulas, to determine the tariff valid for this date (i.e. 4.52, effective from March 2)?

Answer 1

Can.
index+match \ index+searchpos
something like this: