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