View Single Post
  #2   Report Post  
ruci1225 ruci1225 is offline
Junior Member
 
Posts: 2
Thumbs up

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

Please make sure you make this an array.
Hit F2, Ctrl-shift-enter rather than just enter after inputting the 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))