Assuming that you have the corresponding product data in a table then you could use a VLOOKUP instead. Say that you have your drop down lists in Sheet!2. In Sheet3! you have your table with products and their corresponding data in A1:H3.

In Sheet2!B1 use the formula:

=IF(ISNA(VLOOKUP($A1,Sheet3!$A$1:$H$3,COLUMN(B1),FALSE)),"",VLOOKUP($A1,Sheet3!$A$1:$H$3,COLUMN(B1),FALSE))

Copy this accross to column H and then down to row 3. The cells will be blank. From your drop down list in Sheet2! select the product you want from A1,B1 and C1. Your Table in Sheet2! should now look exactly like the one in Sheet!3.

Does that help?

Steve