Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional List
I need help writing a formula that will list the values of B3:B53 for which
A3:A53 is equal to a specifiic value. A3:A53 are set up with dropdown menus to select from a list of values (in this case locations) and I need to have a cell which lists the values in B for each item in the list. Is there a way to do this without creating a mile long if statement? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
datavalidation conditional list | Excel Discussion (Misc queries) | |||
Conditional List | Excel Discussion (Misc queries) | |||
Conditional Drop Down List | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
How do i set up conditional drop-down list | New Users to Excel |