What I would like to do is have a drop-down list that lists all the
divisions/departments of a company, and when I select a particular
division/department from the drop-down list, I would like the box
underneath or anywhere on the worksheet to automatically update with
the appropriate ID number that is assigned to each division. Is this
possible? If so, how can this be done in excel? Thanks.