Determining if a value is within a range when there are gaps/overlaps

[KTow]

I'm analyzing some data. I have information for participant turns (time they start speaking/ time they stop speaking) and I have information for where they are looking at a looking for specific fixations (region of fixation with start times and stop times). I want to compile this information into one sheet where for each point in time (by 1/60th of a second intervals) it shows where the participant is looking and who is talking.

Basically I need the final document be like this:
point in time (For every 1/60th of a sec) - where participant is looking (region 1,2,3,4 or data missing) - who is speaking (X, Y, neither or both)

I've been trying to use VLOOKUP functions but I'm having difficulty because both the fixations and participant turns are ranges with gaps between turns and fixations. Also, for the participant turns there is also overlap between speaking turns.

I've been trying to figure this out all day but not getting anywhere, so any help or suggestion for different approaches would be great.

[Pete_UK]

It would help if you post a sample workbook which showed the data as you have it now and also what you would like to produce from it - the FAQ describes how to attach a workbook.

Pete

[KTow]

Here is some sample data in a workbook. Hopefully it'll make what I'm trying to do more clear.
Thanks

[WHER]

See if the attachment is helpfull.
Warning: if you use the sumproduct based formula's over thousends of rows, they will slow down calculation.