Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Lists Dependencies
Hi All,
i have a problem to solve: I want users to be able to pick a project from a list (no problem) and then i want excel to pick the project number according to the project name automatically from a list. To make my problem clear let's say a user picks Project A from a drop down list in cell A1, then I want excel to display the correct project number in cell B1 automatically. Not all employees know projects by name in our company hence this idea. The best would be to store the project number in a list similar to a list used for drop down menus. The projects change and so do the project numbers hence a easy change of project numbers would be preferable. Thanks in advance for any help on that topic! Adam |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Lists Dependencies
Create a 2 column table like this:
.............A.................B 1.......Name.........Number 2...Project A.........1001 3...Project B.........1201 4...Project C.........3201 5...Project D.........7210 Then, assume your drop down list is in A10. Try this formula in B10: =IF(A10="","",VLOOKUP(A10,A2:B5,2,0)) Biff wrote in message oups.com... Hi All, i have a problem to solve: I want users to be able to pick a project from a list (no problem) and then i want excel to pick the project number according to the project name automatically from a list. To make my problem clear let's say a user picks Project A from a drop down list in cell A1, then I want excel to display the correct project number in cell B1 automatically. Not all employees know projects by name in our company hence this idea. The best would be to store the project number in a list similar to a list used for drop down menus. The projects change and so do the project numbers hence a easy change of project numbers would be preferable. Thanks in advance for any help on that topic! Adam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No Record Source, no dependencies? | Charts and Charting in Excel | |||
Named ranges with dependencies | Excel Discussion (Misc queries) | |||
Drop Down Menu - dependencies | Excel Discussion (Misc queries) | |||
List Dependencies | Excel Discussion (Misc queries) | |||
An .xls template that acts like MSProject? (dependencies, etc) | Excel Discussion (Misc queries) |