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" wrote in message
...
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