How to compare values and output the higher of the two?

Hi,

I currently have a a table with a range of values. These values are used when comparing theoretical values and then selecting an actual value from the table. This can be seen from my excel file attached.

B3 - output value from a calculation
B4 - Criteria to indicate which row in which to perform search
B6 - Theoretical answer from table

Currently, my formula used to calculated and answer for B6 is:

=INDEX(E10:J10,MATCH(MIN(ABS(E10:J10-$B$3)),ABS(E10:J10-$B$3),0))

This formula gives me the value closest to B3 in the range of numbers in the row.

I however would like the formula to give me the highest value between which B3 lies.

eg. B3 = 10 and we have values 9, 15, 20.

My current formula would give me 9, however i would like it to give me 15.

Help would be much appreciated.

Regards
A

Maybe something like:
=MIN(IF(OFFSET(F9:J9,MATCH(B4,OD,0),0)-B3<0,1000,OFFSET(F9:J9,MATCH(B4,OD,0),0)-B3))+B3
as an array formula (confirm with ctrl+shift+enter)

Unfortunately this formula does not work all of the time. if there are any other suggestions, that would be much appreciated.