Find closest value in a range

Good morning (or evening depending on when you are reading this)-
I posted a similar question awhile back and was given a formula that I can't get to work, so I thought I would repost and see if I could some more help.

I am trying make a calculator that will find the corresponding equipment cost based on the payment selected. There are multiple components to this, but part I am having trouble with is getting the payment the customer would enter to match the closest payment according to the range.

I attached a sample worksheet.

TIA!

Hi,

See attached ... is it OK ...?

HTH