You can use programming to do this. There's a sample file here that
fills in a product code, after a product is selected. You could adapt
the technique to your workbook:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0004 - Data Validation Change'


dspitler wrote:
What I am trying to do is create a drop down list where the department is
shown in the list (Art, Style, Photography) but once the name is selected,
the department number shows up. For example, if someone chose Art, I want
the department number to show up in the cell (1000).
Art 1000
Style 1001
Photo 1002
Please help! Thanks so much.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html