Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding an item in a list & returning a specific value | Excel Worksheet Functions | |||
Returning the most duplicated item | Excel Worksheet Functions | |||
GET.CHART.ITEM returning strange results | Charts and Charting in Excel | |||
Returning the last item in column | New Users to Excel | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |