Excel Lists Dependencies

[adamrobak]

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

 

[T. Valko]

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