To return the value for the selected item, you can use a VLookup
formula. There are instructions and examples he

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

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

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

Under Data Validation, look for 'Order Form'


jason n z wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html