So, for any given City, there is only one 'ship-to' address? That is, the
destination in Los Angeles is always the same business/street address in Los
Angeles, while the destination in Atlanta is always to the same
business/street address in Atlanta?

"cra88" wrote:

I am trying to simplify my shipping documents within Excel. I have created a
drop down list by cities of my shipping destinations. I need to populate the
entire shipping addresses that are in another sheet within the workbook. It
can be in the column or row next to the drop down list. The addresses will
also be multiple cells, not just one cell.

Any help would be appreciated.