table look up problem

[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

 

[gilbert]

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