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

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

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


Abi wrote:
I'm working with Excel 97, but will be getting upgraded to the newest version
in a few days.

I would like to be able to create a two column list on one sheet - one
column has products and the other has prices. Then, on another sheet I would
like a user to be able to use a dropdown, or a form, to be able to select one
or more of these products (along with their adjoining price) to add to a new
sheet, or to remove as necessary.

I've seen something like this done before, but I'm not sure how to do it. I
can't use Access (which would be ideal) because no one else has it, and I
need multiple people to use this.

any help or suggestion are greatly appreciated!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html