Excel 2003 - Drop Down List
 

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

Excel 2003 - Drop Down List
 

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

Excel 2003 - Drop Down List
 

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

"Cimjet" wrote:

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

Excel 2003 - Drop Down List
 

Hi Again
If your having problems with that, I can send you a sample file by link.
Good luck
Cimjet
"sparklydaisy" wrote in message
...
Thanks for the ideas. I'll give that a try. Thanks again!

"Cimjet" wrote:

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

Excel 2003 - Drop Down List
 

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

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

"Cimjet" wrote:


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




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html