Long string of IF formulas
 

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 Namedefine
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


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=554236

Long string of IF formulas
 

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

Long string of IF formulas
 

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
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=554236

Long string of IF formulas
 

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
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=554236