Show price rate from a date range

this should work for you in C8 (dragged right) based on a couple things...
=SUMPRODUCT($L$8:$L$31,($I$8:$I$31=C$7)*($A$2>$J$8:$J$31)*($A$2<$K$8:$K$31))
thing 1) change "AD " in C7 to "AD" without the space at the end because it won't match otherwise for what in in column I.
thing 2) make same change to "NIÑO " as it also has a trailing space.
thing 3) you have TODAY() in cell A2 and that date doesn't fall into any of the dates in your start date and end date range so just to verify it works I put in 12/31/2020 into A2 and it worked.
hope that helps.

You are very welcome, AND thank you for the rep!