find where a number in a range of numbers is with formulas

[stratis63]

I have sessions ranges of time (ticketing sessions) Sheet 2 filed Gray
i have also events in another file.
I need a function that looks at an event time and dates and returns to me the corresponding session

For example
File 1
A
FILE A
Code, Sport, Date, Start time, End time of a session
Session 1, HB, 01/07/2012 08.00 -12.00
Session 1, HB, 01/07/2012 12.01 -16.00

and then I do have events
FILE B
event,Sport, Date, Start time
Match 1, HB, 01/07/2012, 09.15


So I need the function will look at the FILE Bt combining for example Sport+Date+time
and then will look in FILE A sessions Again Sport+date+start time, Sport+ date+endtime and will decide which session includes that event

in our example The formula should return

match 1, Session1
so I need a function that will look up in the index or area of the sessions and will return the one that corresponds to the time.


Regards
​