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),F ALSE)),"",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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=554236