I need to build a computer, and list the parts and prices.

[Guest]

I need to build an expensive computer, and a reasonable computer. How can I
list the parts and prices in the excel program?

 

[Debra Dalgleish]

Create a list with part names in one column, and prices in the next
column, e.g.:

Part Price
4X DVD+/-RW Drive $250

Then, on another sheet, you can create a dropdown list of parts by using
data validation. There are instructions here:

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

To return the price for the selected part, you can use VLookup formulas.
There are instructions here:

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