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

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

Perhaps VLOOKUP would be helpful.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"terilad" <(E-Mail Removed)> wrote in message
news:38E08AF0-F53A-4487-BA63-(E-Mail Removed)...
>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

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

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
> (E-Mail Removed)
> "terilad" <(E-Mail Removed)> wrote in message
> news:38E08AF0-F53A-4487-BA63-(E-Mail Removed)...
> >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
>
>

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

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

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" <(E-Mail Removed)> wrote in message
news:3704306B-4733-4BA3-BEC6-(E-Mail Removed)...
> 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
>> (E-Mail Removed)
>> "terilad" <(E-Mail Removed)> wrote in message
>> news:38E08AF0-F53A-4487-BA63-(E-Mail Removed)...
>> >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
>>
>>