I have a table where cell E2 what I want to start from.
Table is cells F2 to H2. E2=$26.31, F2=$24.75, G2=$25.82, H2=$26.90

What I want to do (can't think of it today) is to select the rate
closest to but not less than E2 from cells F2 to H2.

Not sure what is the best/efficient way to do this.

thx

Mel

On Jun 26, 10:21*am, Mel wrote:
I have a table where cell E2 what I want to start from.
Table is cells F2 to H2. * E2=$26.31, F2=$24.75, G2=$25.82, H2=$26.90

What I want to do (can't think of it today) is to select the rate
closest to butnotlessthanE2 from cells F2 to H2.

Notsure what is the best/efficient way to do this.

thx

Mel

to add, I have an array formula that works but does not pick the
closest to but less than.
it picks the less than and I need it to pick the next one up.

INDEX(A1:C1,MATCH(MIN(ABS(A1:C1-A5)),ABS(A1:C1-A5),0))

this formula gives the result of 25.52 when the result should be 26.90