Lookup/Index/Match to Return Value of Higher number rather than lower# when inbetween

Hello ExcelForum

I have a table of values in ascending order that go along with a match function to return values in a specified cell. When there is a number to lookup that is inbetween values in the table, the function returns a value coresponding to the lower number rather than the higher number.

Is there a way to manipulate the function to give me the higher number's coresponding value?

My sheet is attached here Density Pay.xlsx .

Thank you in advance!

Originally Posted by msexcelathome

You can use the Match type as -1 instead of 1 which you have used, But for that, the data needs for be sorted descending..

Thanks msexcelathome,

At first I was frustrated because I had already tried that. Then I realized, I needed to truncate my values in J5 etc to get the correct value from the table!
Much Love to ExcelForum! You guys are always very helpful!