Help with Validation (drop-down list)

[mike schmidt]

I would like to be to choose a city from a drop-down list, and then populate
adjacent fields with the address, phone number, account number, etc,
associated with that city .

Is this easily done?

For example - I chose Atlanta from a drop-down list and put Atlanta into D1.
I would then like the street address, zip, code, etc. put automatically into
D2, D3, ...


Thaks for any help!!!

 

[Frank Kabel]

Hi
use a combination of 'Data - Validation - List' and VLOOKUP. See the
following sites:
http://www.contextures.com/xlDataVal01.html
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/validation_and_indirect.zip
It's in the "Worksheet (No VBA)" section on page:
http://www.bygsoftware.com/examples/examples.htm

Shows how using "Data > Validation" and "INDIRECT()" you can populate a cell
from two dependant lists


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"