Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Fill
I have cells that are under day Monday on a shift resource cells are
D8, E10, D14, D18, when I fill these cells with a name J. Smith, I need cell M4 to display either 07:00 - 19:00 or 07:00 - 15:00 or 15:00 - 23:00 or 19:00 - 07:00 depending on what shift times the name is entered in. So if I enter J. Smith in cell D8 I need cell M4 to report 07:00 - 15:00 or if I enter J. Smith into cell D14 I nedd cell M4 to report 15:00 - 23:00. The same name will never be entered into more than 1 cell per day. Can anyone give me some help on this. Regards Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Fill
You specified the required content of M4 only for cases when D8 and D14 is
filled. What should M4 contain whwn E10 and D18 is filled? Stefi €˛terilad€¯ ezt Ć*rta: I have cells that are under day Monday on a shift resource cells are D8, E10, D14, D18, when I fill these cells with a name J. Smith, I need cell M4 to display either 07:00 - 19:00 or 07:00 - 15:00 or 15:00 - 23:00 or 19:00 - 07:00 depending on what shift times the name is entered in. So if I enter J. Smith in cell D8 I need cell M4 to report 07:00 - 15:00 or if I enter J. Smith into cell D14 I nedd cell M4 to report 15:00 - 23:00. The same name will never be entered into more than 1 cell per day. Can anyone give me some help on this. Regards Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Fill
Perhaps VLOOKUP would be helpful.
-- Don Guillett Microsoft MVP Excel SalesAid Software "terilad" wrote in message ... I have cells that are under day Monday on a shift resource cells are D8, E10, D14, D18, when I fill these cells with a name J. Smith, I need cell M4 to display either 07:00 - 19:00 or 07:00 - 15:00 or 15:00 - 23:00 or 19:00 - 07:00 depending on what shift times the name is entered in. So if I enter J. Smith in cell D8 I need cell M4 to report 07:00 - 15:00 or if I enter J. Smith into cell D14 I nedd cell M4 to report 15:00 - 23:00. The same name will never be entered into more than 1 cell per day. Can anyone give me some help on this. Regards Mark |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Fill
E10 07:00 - 19:00
D18 19:00 - 07:00 Regards "Stefi" wrote: You specified the required content of M4 only for cases when D8 and D14 is filled. What should M4 contain whwn E10 and D18 is filled? Stefi €˛terilad€¯ ezt Ć*rta: I have cells that are under day Monday on a shift resource cells are D8, E10, D14, D18, when I fill these cells with a name J. Smith, I need cell M4 to display either 07:00 - 19:00 or 07:00 - 15:00 or 15:00 - 23:00 or 19:00 - 07:00 depending on what shift times the name is entered in. So if I enter J. Smith in cell D8 I need cell M4 to report 07:00 - 15:00 or if I enter J. Smith into cell D14 I nedd cell M4 to report 15:00 - 23:00. The same name will never be entered into more than 1 cell per day. Can anyone give me some help on this. Regards Mark |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Fill
I have given VLOOKUP a go but I can only input one cell as the LOOKUP cell,
can you give an example of adding multiple cells to the LOOKUP function. Thanks Mark "Don Guillett" wrote: Perhaps VLOOKUP would be helpful. -- Don Guillett Microsoft MVP Excel SalesAid Software "terilad" wrote in message ... I have cells that are under day Monday on a shift resource cells are D8, E10, D14, D18, when I fill these cells with a name J. Smith, I need cell M4 to display either 07:00 - 19:00 or 07:00 - 15:00 or 15:00 - 23:00 or 19:00 - 07:00 depending on what shift times the name is entered in. So if I enter J. Smith in cell D8 I need cell M4 to report 07:00 - 15:00 or if I enter J. Smith into cell D14 I nedd cell M4 to report 15:00 - 23:00. The same name will never be entered into more than 1 cell per day. Can anyone give me some help on this. Regards Mark |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Fill
I tried to generalize the job:
If you have the name to search for (J. Smith) in (say) L4 and all cells to be filled are in column D (use D10 instead of E10) and intervals are assigned to rows in column E (E8= 07:00 - 15:00, E10= 07:00 - 19:00, etc.) then =VLOOKUP(L4,D:E,2,FALSE) in M4 returns J. Smith's shift. If you want to keep E10, then you need a more complex formula. It wouldn't be very logical. Stefi €˛terilad€¯ ezt Ć*rta: E10 07:00 - 19:00 D18 19:00 - 07:00 Regards "Stefi" wrote: You specified the required content of M4 only for cases when D8 and D14 is filled. What should M4 contain whwn E10 and D18 is filled? Stefi €˛terilad€¯ ezt Ć*rta: I have cells that are under day Monday on a shift resource cells are D8, E10, D14, D18, when I fill these cells with a name J. Smith, I need cell M4 to display either 07:00 - 19:00 or 07:00 - 15:00 or 15:00 - 23:00 or 19:00 - 07:00 depending on what shift times the name is entered in. So if I enter J. Smith in cell D8 I need cell M4 to report 07:00 - 15:00 or if I enter J. Smith into cell D14 I nedd cell M4 to report 15:00 - 23:00. The same name will never be entered into more than 1 cell per day. Can anyone give me some help on this. Regards Mark |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Fill
I have trie this and does not work, I need the shift to time in M4 at all
times and perate for multiple cells to be lookup function "Stefi" wrote: I tried to generalize the job: If you have the name to search for (J. Smith) in (say) L4 and all cells to be filled are in column D (use D10 instead of E10) and intervals are assigned to rows in column E (E8= 07:00 - 15:00, E10= 07:00 - 19:00, etc.) then =VLOOKUP(L4,D:E,2,FALSE) in M4 returns J. Smith's shift. If you want to keep E10, then you need a more complex formula. It wouldn't be very logical. Stefi €˛terilad€¯ ezt Ć*rta: E10 07:00 - 19:00 D18 19:00 - 07:00 Regards "Stefi" wrote: You specified the required content of M4 only for cases when D8 and D14 is filled. What should M4 contain whwn E10 and D18 is filled? Stefi €˛terilad€¯ ezt Ć*rta: I have cells that are under day Monday on a shift resource cells are D8, E10, D14, D18, when I fill these cells with a name J. Smith, I need cell M4 to display either 07:00 - 19:00 or 07:00 - 15:00 or 15:00 - 23:00 or 19:00 - 07:00 depending on what shift times the name is entered in. So if I enter J. Smith in cell D8 I need cell M4 to report 07:00 - 15:00 or if I enter J. Smith into cell D14 I nedd cell M4 to report 15:00 - 23:00. The same name will never be entered into more than 1 cell per day. Can anyone give me some help on this. Regards Mark |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Fill
if you want to use multiple cells, then you'll be best to add a new column
and concatenate the data from the columns to so if A1 B1 and C1 are three items to look up, in D1 =A1 & B1 & C1 if your table is say K1: Tnn then in J1 put =K1 & L1 & M1 (whatever cols equate to your A,B & C cols "terilad" wrote in message ... I have given VLOOKUP a go but I can only input one cell as the LOOKUP cell, can you give an example of adding multiple cells to the LOOKUP function. Thanks Mark "Don Guillett" wrote: Perhaps VLOOKUP would be helpful. -- Don Guillett Microsoft MVP Excel SalesAid Software "terilad" wrote in message ... I have cells that are under day Monday on a shift resource cells are D8, E10, D14, D18, when I fill these cells with a name J. Smith, I need cell M4 to display either 07:00 - 19:00 or 07:00 - 15:00 or 15:00 - 23:00 or 19:00 - 07:00 depending on what shift times the name is entered in. So if I enter J. Smith in cell D8 I need cell M4 to report 07:00 - 15:00 or if I enter J. Smith into cell D14 I nedd cell M4 to report 15:00 - 23:00. The same name will never be entered into more than 1 cell per day. Can anyone give me some help on this. Regards Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Fill Cell Based on Data in a different cell | Excel Discussion (Misc queries) | |||
remove fill in text from a cell from an unpopulated fill-in cell | Excel Worksheet Functions | |||
Code to copy cell borders and fill color from one cell to another | Excel Programming | |||
How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions |