View Single Post
  #1   Report Post  
BDAvs BDAvs is offline
Junior Member
 
Posts: 13
Default Returning next item in list

Column A = Sizes. Cell D6 = Dropdown of sizes in column A. In D6, when I choose, .2500, I'd like to return the next 3 sizes (.2625-.2830) in cells D7-D9. I've been trying to find a good formula with index/match functions.

Col A (data) ...Col D
.1620
.1770
.1875
.1920
.2070
.2187 .... .2500 (Chosen from dropdown)
.2253 .... .2625 (need formula)
.2343 .... .2730 "
.2437 .... .2830 "
.2500
.2625
.2730
.2830
...

Thanks in advance for any help.

Last edited by BDAvs : August 14th 12 at 09:25 PM