Long string of IF formulas

[changetires]

I am writing a sheet containing multiple products. For these different
products there are certain steps of manufacturing that require time.
What I am wanting to do is when a certain product is entered into the
sheet I want the time in just total hours format to be displayed under
the steps that are listed in the sheet. I have made a product list on
another sheet and have that linked with data validation. These
products are listed in cell A1 with a pull down menu using Name>define
and data validation so when I pull certain products out I get this

Cell A1 is product A, but I want Cell C1 to display 2;Cell D1 to
display 4;Cell E1 to display 6;Cell F1 to display 3. then on Cell B1
I will pull down product B and then I will need Cell C1 to display 4;
Cell D1 to display 2; Cell E1 to display 5.

This is what I am wanting to do unless there is an easier way cause
this could go on with about 20 to 100 different products.
Here is an example of a current table. This table could grow much
larger.
Product Chg EvDy TfrDeo Neu Dist Fil Clean
BDP

Product A 2 2 2 2 4 6 19
Product B 4 5 3 2 2 3 19
Product C 2 4 2 3 3 4 20

Ed

 

[SteveG]

Assuming that you have the corresponding product data in a table the
you could use a VLOOKUP instead. Say that you have your drop dow
lists in Sheet!2. In Sheet3! you have your table with products an
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 wil
be blank. From your drop down list in Sheet2! select the product yo
want from A1,B1 and C1. Your Table in Sheet2! should now look exactl
like the one in Sheet!3.

Does that help?

Stev

 

[changetires]

Steve,

I am not sure if excel can perform this function. One thing I didnt
mention is that this sheet I am making will also get larger due to the
fact that as I select a product from the pull down and then enter in
all my time data for the different cycles, my next line down will be a
new product that I am entering for the next cycle. The cells where I
want the cycle times of the different products to appear will have to
have a formula that looks at the next product cell in-line before it
can put in the correct cycle times. If this isnt clear it will be ok.

Thanks again
Ed

 

[changetires]

Steve,

I am not sure if excel can perform this function. One thing I didn
mention is that this sheet I am making will also get larger due to th
fact that as I select a product from the pull down and then enter i
all my time data for the different cycles, my next line down will be
new product that I am entering for the next cycle. The cells where
want the cycle times of the different products to appear will have t
have a formula that looks at the next product cell in-line before i
can put in the correct cycle times. If this isnt clear it will be ok.

Thanks again
E