Match/Lookup?...No unique identifier

Hi,

I hope someone can help with this....

I have 2 reports coming out of 2 seperate systems. To make things simpler I have put an example of report 1 on sheet 1 and report 2 on sheet 2.

On sheet 2 column G, I need to populate the 'Interaction ID' from sheet 1 column A. This way I'll be able to tie together the two reports.

Here's what I need it to check;
1. Sheet 1 column C is the time a call is taken and column H is the time the call ended. Sheet 2 column F is the time the sale was processed so this time on sheet 2 column F will fall in between the two times on sheet 1 columns C & H.
2. The agent has to be looked up as there are multiple agents taking calls so there will be multiple times that are similar.
3. The date also has to match as the agent could take a call at 9am on 1st November and 9am on 2nd November and they will be on the same report, so I need it to match the date too.

If this can be done then is should return the interaction_ID from sheet 1 column A.

PLEASE NOTE: Not all formulas in Sheet 2 column G will return an Interaction_ID if no sale was made on the call. e.g. Cell G1, G2 in sheet 2 should return blank and cell G3 should return interaction_ID 67383144.

I hope that all makes sense...... :S

Thanks in advance!

Scott.