Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to count based on data in two different cells/columns | Excel Discussion (Misc queries) | |||
Getting data from another workbook based on variable | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |