Hi Dries,
You might also look at combo box, see
http://www.contextures.com/tiptech.html
http://www.contextures.com/xlDataVal10.html
and introductory videos at
http://www.datapigtechnologies.com/ExcelMain.htm
Data Validation in Excel (1st half is on date, 2nd is on a list)

You can fill in more detail later from a table, like the price and weight using VLOOKUP
http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
\Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"CLR" wrote...
such as "closet", Then you can do Data Filter AutoFilter, and select
"closet" in that product column and Excel will display only those parts that
are used in the "closet" product.

"Dries" wrote:
if I type 'Corpus' (or select it in some sort of a pop up menu)
the formulas (attached to it?) have to appear automatically
actually it's for calculating prices, so if I want to calculate a
certain closet, I have to choose the different parts (like corpus or
door) with the different formulas attached (because there are different
doors).