I'm creating a purchase order form. I need the delivery address to show one
of three potential delivery location. Two of these locations are already
input into the worksheet. I want them to be displayed in the delivery address
cell.
The delivery address displayed will be dependant on the result of the user
populating a cell from a drop down list.
An example would be where the purchase order has a Design Agency Address and
a Customer Address already entered. The user would choose, in a cell, from a
drop down that had "Agency, Customer, Other" Dependant on which of these they
select. I want the worksheet to look in the cell that corresponds with either
the agency or customer address and display it in the delivery address.