Drop down choice sends text to another cell

[Guest]

I would like a drop down selection (City) to automatically input a
predetermined street address into another cell (different street based on the
city selected). I think it's a macro associated with the change event of the
drop down. I can do vba but I need a suggestion as to what the vba would do.
Thanks for any help.

 

[Guest]

You can use VBA for this, but there is little adantage. The VBA would need a
lookup table to get the street address anyway.

Just create a lookup table on the worksheet and use the VLOOKUP() function
to return the correct street address based upon the dropdown cell.

 

[Guest]

The combo box with the city is currently an active x control that is not near
the cell with the street address. I've only done vlookup when everything was
"connected"--the matching item and lookup value. These cells are currently
not next to each other. My two questions now are:

Do I need to convert the active x control to a look up list (so it's
actually in a cell)? AND
Do I have to redesign my spreadsheet so the cells are next to each other?