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.
--
Gary''s Student - gsnu200723


"Andy" wrote:

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.