| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return list from a list
I have a list of customers, and each customer has a list of their model
names. Eg. Customer: A, Model: A1, A2, A3.. B, Model: B1, B2, B3... C, Model: C1, C2, C3.... I want my excel column A to display the list of customer and for me to choose one (which i know i can do so by "validation", and choose list) Then i want the column B to display the list of models correspond to the column A selection. Meaning if i choose customer A from the list, column B should display the list is B1,B2,B3... then i choose one of them from the list (like the "validation"). But i dunno how to do so with excel. can any one teach me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a list dependent upon the selection of a preceeding list | Excel Worksheet Functions | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| return a list | Excel Worksheet Functions | |||
| return one value from list | Excel Worksheet Functions | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
Threaded Mode
