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?