View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mel[_5_] Mel[_5_] is offline
external usenet poster
 
Posts: 16
Default lookup a rate in a tabel closest to but not less than

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