Re: Excel 2003 - Drop Down List

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <sparklydaisy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:57F94289-A274-4F07-B670-F6230B58DA91@xxxxxxxxxxxxxxxx

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 spread***
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

.

Quantcast