Schedule help: formula based on 3 choices of data?
I am creating a construction schedule: one row has each step and the columns
have the customers. The data will be date driven. I need a fixed number of days to populate the schedule based on the user choosing one of 3 items (A,B,C). Each represents a type of job and each have a different number of days. If "A" is selected, I want Excel to look at row (a1:h1). If "B" is selected I want Excel to look at row (a2:h2) and if "C" is selected I want it to look at (a3:h3). These rows contain a number (for days). In the first cell, I have a date that drives the formula. I don't know how to get Excel to select the appropriate row based on the user selection and then add it to my date. Does anyone know a formula that allows a lookup of criteria based on 3 choices? |
Schedule help: formula based on 3 choices of data?
I'm not sure exactly what you want to do, but something like this would
work: =IF(A1="A",lookup(...a1:h1...),IF(A1="B",lookup(.. .a2:h2...), IF(A1="C",lookup(...a3:h3...),"none"))) Hope this helps. Pete |
Schedule help: formula based on 3 choices of data?
Thank you for the help! What I'm trying to do is take a fixed start date
(4/1/06) and add 1 day (=IF(G9=0,"",WORKDAY(G9,$I$2))) to it using this formula. The problem I have is the (1) day is the variable. If you enter "A" it is 1 day, if you enter "B" it's 2 days and if you enter "C" it's 3 days. How do I get this to work? AND THANK YOU, AGAIN FOR HELPING!! "Pete_UK" wrote: I'm not sure exactly what you want to do, but something like this would work: =IF(A1="A",lookup(...a1:h1...),IF(A1="B",lookup(.. .a2:h2...), IF(A1="C",lookup(...a3:h3...),"none"))) Hope this helps. Pete |
Schedule help: formula based on 3 choices of data?
Try this:
=IF(G9=0,"",WORKDAY(G9,MATCH($I$2,{"A","B","C"},0) )) Biff "TNT" wrote in message ... Thank you for the help! What I'm trying to do is take a fixed start date (4/1/06) and add 1 day (=IF(G9=0,"",WORKDAY(G9,$I$2))) to it using this formula. The problem I have is the (1) day is the variable. If you enter "A" it is 1 day, if you enter "B" it's 2 days and if you enter "C" it's 3 days. How do I get this to work? AND THANK YOU, AGAIN FOR HELPING!! "Pete_UK" wrote: I'm not sure exactly what you want to do, but something like this would work: =IF(A1="A",lookup(...a1:h1...),IF(A1="B",lookup(.. .a2:h2...), IF(A1="C",lookup(...a3:h3...),"none"))) Hope this helps. Pete |
All times are GMT +1. The time now is 07:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com