Retrieving the Closest Larger / Closest Smaller Values from a List

Hello all,

I was looking for an option how do I retrieve the closest smaller number from a list and have come across to this article.
https://www.exceltip.com/lookup-form...act-match.html

The function works well on on the file downloaded but if I insert my numbers (7digits long) into the list the function does not return the smaller number but the same exact number.

Ideally I would need function to match two columns instead of just one.

closest smaller number.PNG

3200 doesn't exist in column so formula show closest value
4843017 exist so why it should show another value?
change 4843017 to 4843016 and you will see

I don't understand, my file is still not returning right values but instead same number.

closest smaller number2.PNG

Originally Posted by sandy666

3200 doesn't exist in column so formula show closest value
4843017 exist so why it should show another value?
change 4843017 to 4843016 and you will see

Ahhh... I got it now. But what if I want to return the closest smaller value to the value im looking up even if the same number is present in the list?

Change +1 to +0

If the basic problem is solved
- it's always a good practice to show respect to the person(s) who have helped you
- is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you)
Thanks

User canapone was the first one who answered my question so I have awarded him with reputation. Thank you for your understanding.

Of course Like I said:

Originally Posted by sandy666

...to show respect to the person(s) who have helped you