Returning next item in list

[BDAvs]

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

A (data) ...
.162
.177
.187
.192
.207
.2187 .... .2500 (Chosen from dropdown
.2253 .... .2625 (need formula
.2343 .... .2730
.2437 .... .2830
.250
.262
.273
.283
..

Thanks in advance for any help

 

[Claus Busch]

Hi,

Am Tue, 14 Aug 2012 14:08:31 +0000 schrieb BDAvs:

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.

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

if you have a header in Column A, then in D7:
=INDEX(A:A,MATCH(TRUE,($A$2:$A$14)>D6,0)+1)
without header:
=INDEX(A:A,MATCH(TRUE,($A$1:$A$14)>D6,0))

both are array formulas to enter with CTRL+Shift+Enter


Regards
Claus Busch