Excel 2003 - Drop Down List

[sparklydaisy]

Hi There,

I was wondering if it is possible to have a drop down list put values into
different cells?

For example: Down down box lists 10 different locations. When a location
is selected I'd like to have several other fields in the same spreadsheet
filled with related data, based on the location selected. (for example:
Address, City, Postal Code.)

Any help would be appreciated. Thanks!

Gloria

 

[Cimjet]

Hi Sparklydaisy
If I understand you well, you could use a Data Validation table for your
drop-down list and Vlookup formula for the other fields
Regards
Cimjet

 

[sparklydaisy]

Thanks for the ideas. I'll give that a try. Thanks again!

 

[Cimjet]

Hi Again
If your having problems with that, I can send you a sample file by link.
Good luck
Cimjet

 

[Debra Dalgleish]

There are instructions and a sample file here, for an order form with
data validation lists and VLookup formulas:

http://www.contextures.com/xlOrderForm01.html