Vlookup Multiple Criteria - Please help

[ruci1225]

I have the following data in my excel workbook.
I am trying to match customer data to call data. Below find a simplifie
explanation of how the workbook is laid out.

Worksheet 1 (customer data):

(A) - Customer Unique Identifier
(B) - Phone 1
(C) - Phone 2
(D) - Phone 3
(E) - RequestDate

Worksheet 2 (call data)

(A) - Call unique Identifier
(B) - Phone Number Dialed
(C) - Connected Date Time


I am trying to create a lookup that will perform the following:

For each item in Worksheet1 (A), match Worksheet1 (B), (C), or (D) t
Worksheet 2 (B) and bring back the first instance of (C) that is equa
to or greater than Worksheet1 (E) back to worksheet 1.

At first I tried a vlookup but I only based it on 1 phone number i
Worksheet 1 and Worksheet2 (C) at times was before the date i
worksheet1.


Please let me know the best way to approach this

 

[ruci1225]

For anyone interested, I was able to resolve this using the followin
formula:

Please make sure you make this an array.
Hit F2, Ctrl-shift-enter rather than just enter after inputting th
formula.

=INDEX(CallData!$C$2:$C$9,MATCH(1,
IF(ISNUMBER(MATCH(CallData!$B$2:$B$9,$B2:$D2,0)),
IF(CallData!$C$2:$C$9>=$E2,1)),0)