Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Value & Length Dependent
Hello,
I have a "Rate Sheet" in my workbook that pulls information from a shipping price database in worksheet 2. It is set up using Index/Match & *Lookup functions dependent on what entered in cell labeled "SHIP FROM" cell A2 & "SHIP TO" cell b2. The user currently has to type the ship to & from cities in these cells. I want to change so that A2 is a validation list of only unique "SHIP FROM" entries from the corresponding column in database. & B2 to be a validation list of "SHIP TO"s that corresponds to the ship froms in data base. To complicate things not every "SHIP FROM" location in database has the same number of "SHIP TO"s and I want the B2 to only list the exact number of possible combinations. I know there are several problems posed here but did not want to post multiple questions. Thanks in advance for your trusted assistance. ST |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Dependent Drop Down lists? | Excel Discussion (Misc queries) | |||
dependent drop down boxes and dynamic ranges | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
how do I insert drop down menus into excel that are dependent on . | Excel Discussion (Misc queries) | |||
drop down menu length | Excel Worksheet Functions |