| 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 |
| 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 | |||
Threaded Mode
