ExcelBanter - Returning next item in list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Returning next item in list (https://www.excelbanter.com/excel-worksheet-functions/446843-returning-next-item-list.html)

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.

Returning next item in list

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2