drop down list

[Guest]

Hello,
I am hoping someone out there can help me with my current problem. I would
like to use a drop down list and when a specific item is chosen the next
couple of cells below it are populated with data depending on which item was
selected.

Is this possible or relatively easy to do if so how do I go about doing it.

Thanks for your time. Any input is appreciated.
c

 

[Debra Dalgleish]

You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and here:

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

To return the related information for the selected item, you can use a
VLookup formula. There are instructions and examples here:

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

There's a sample file that uses Data Validation and VLookup formulas here:

http://www.contextures.com/excelfiles.html#Function

Under Data Validation, look for 'Order Form'

 

[Gord Dibben]

c

You could use the VLOOKUP Function with a table.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlFunctions02.html

While you're there check out using Data Validation drop-downs for entering
values to lookup.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP