+ Reply to Thread
Results 1 to 4 of 4

Long string of IF formulas

  1. 06-21-2006, 01:35 PM #1
    changetires
    changetires is offline
    Registered User
    Join Date
    06-14-2006
    Posts
    72

    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 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
    Last edited by changetires; 06-21-2006 at 02:14 PM.
    Reply With QuoteRegister To Reply
  2. 06-21-2006, 02:20 PM #2
    SteveG
    SteveG is offline
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094
    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
    Reply With QuoteRegister To Reply
  3. 06-21-2006, 03:48 PM #3
    changetires
    changetires is offline
    Registered User
    Join Date
    06-14-2006
    Posts
    72
    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
    Reply With QuoteRegister To Reply
  4. 06-21-2006, 03:59 PM #4
    changetires
    changetires is offline
    Registered User
    Join Date
    06-14-2006
    Posts
    72
    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1