I am unsure what this would be called or if for that matter it is even
possible in excel. I would like to create a pull down list containing city
names and then based on the city chosen in the list, have an address
automatically fill in another cell/cells located on the same sheet.

I am trying to create a purchase order that can be primarily filled out
using the mouse and can be fairly automated based upon certain standard
selections. Any direction would be appreciated.
--
Best,
-HB