Schedule help: formula based on 3 choices of data?

T

TNT

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?
 
P

Pete_UK

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
 
T

TNT

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!!
 
Top