table look up problem

  • Thread starter Thread starter Andre C
  • Start date Start date
A

Andre C

The problem revolves around people's duty roster.

The table looks like this

jan 1 start jan 1 stop jan 2 start jan 2 stop ...
fred 8am 3pm 3pm 6pm
jane 3pm 6pm
john 8am 3pm
peter


The times are in 24 hour format in actual fact. What I want to achieve
is the following outcome table


hours jan 1 jan 2
8 fred john
9 fred john
10 fred john
11 fred john
12 fred john
13 fred john
14 fred john
15 jane fred
16 jane fred
17 jane fred
18 jane fred

To complicate matters futher there can be over lap of hours.

I have looked as LOOKUP and MATCH etc but can't kind find a solution.

Andre
 
Hi AndreC,

I am sure I get full understanding of your requirements...maybe yo
could adopt IF function rather than lookup. Maybe, you can email m
your worksheet and I will see if anything I can help. My email i
(e-mail address removed)

Please state "Excel Forum : xxx" in the subject line...otherwise,
would delete of as if it is junk mail.

Thank you..

RGds,
Gilber
 
Back
Top