Cell Fill

  • Thread starter Thread starter terilad
  • Start date Start date
T

terilad

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:
 
E10 07:00 - 19:00
D18 19:00 - 07:00

Regards

Stefi said:
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:
Click to expand...
 
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
 
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:
 
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
 
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
 
Back
Top