auto populate cells with values based on a known value that falls on or between data from 2 columns

i want to auto-populate 2 cells based on constraints related to a known value.

Using the below data:

I want to populate cells B22 and C22 with values from row 6, based on the value in cell B12.

For example, if B12 is 0.2, I would like to populate B22 with 5000 and C22 with 10000 as 0.2 falls somewhere between those 2 columns in my data set.

Using =forecast.linear, i've already got the calculation to determine the exact value between the 5000 and 10000, but i currently have to find which 2 columns my known value falls between and then manually enter the numbers into B22 and C22.

I was hoping there was a statement that would populate the cells for me.

https://preview.redd.it/ps9uaoqn0yig1.png?width=607&format=png&auto=webp&s=f6fd719fa2b4906c930739d19175ca07ca1a95b1

Thanks