Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up a value in a list & returning multiple corresponding va
Complete Subject: Looking up a value in a list & returning multiple
corresponding values in an in-cell dropdown Column A = list of Program numbers Column B = list of Project numbers For a given Program number there can be one or more Project numbers. Consequently, Column A contains duplicate Program numbers. Cell C1 = a user inputs a Program number Cell D1 = I would like to display an in-cell dropdown with the list of Project numbers associated with the inputted Program number in cell C1 I looked at a potential solution I found at http://office.microsoft.com/en-us/ex...1033#backtotop. Using a named range, I can get the results to appear in an in-cell dropdown. However, since the number of results will vary by Program number, I have not been able to figure out how NOT to display "blank" results in the in-cell dropdown. For example, if I create a four-cell named range, but the number of results (i.e., Project numbers) for a given Program number is only two, the in-cell dropdown displays the two Project numbers as well as two blank "placeholders". Any help would be greatly appreciated. Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning multiple values from a list | Excel Discussion (Misc queries) | |||
Sort multiple columns with multiple formulas without returning #R | Excel Worksheet Functions | |||
Returning multiple corresponding values using lookup in a list | Excel Discussion (Misc queries) | |||
Returning next value from a list | Excel Worksheet Functions | |||
Returning list values | Excel Worksheet Functions |