I would like to create a drop down list of number that, when selected, will
automatically fill out the the next cell with a name i.e.

I select No. 120 and the next cell automatically fills out the name as being
Angela9520. How can I do that? Ostensible I want to select a number and
have the name associated with that number appear in the next cell!