Pull down lists

[jason n z]

i have created a pull down list and want to assign values to any of the
options selected by the user. eg user selects option 1 i want that selection
to look for a value from somewhere in the sheet and put it in a corresponding
cell

 

[Debra Dalgleish]

To return the value 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'