Searching an array from bottom to top

I have a table array $E$14:$G$851. Column E just contains unique identifiers, lets say a/b/c/d etc, column F contains hundreds of numbers all less than or equal to 20 and column G contains the values I need retued.

I need a formula which will search for the unique identifier in column E, and then search UP column F and find me the FIRST value that is LESS THAN the column F result and use that result to retu the adjacent value in column G.

So if I had searched for "g", the formula would then search UP column F for the first number LESS THAN 16. This would be "d" with 12. the formula would then retu 25010 from column G.

example

I've been searching for an answer to this for weeks and haven't found any examples of excel searching an array from bottom to top. I'd strongly prefer to not change the data layout (such as flipping it).

Please let me know if you have an solutions, Thanks!

Leon

- - , .
.

Recent Questions...