• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Finding Text String Within A Time Period

C

Christof

Member
Hi All,
I have two tables, one that displays calls and one that displays bookings (file attached).
I can make an assumption that bookings are only made while the person is on the phone.
So can I get my calls table to show what holiday was booked and what the revenue was.
The booking has to have occurred whilst the Salesman was on the phone, which we can tell from their CallTime and CallEndTime.

This is probably quite simple but ive been staring at it too long without a solution.

Many thanks
Chris
 

Attachments

  • Calls Booking Example.xlsx
    10.8 KB · Views: 3
Try,

In F2, Copied right to G2, and all copied down :

=IFERROR(INDEX(Booking!D$1:D$100,MATCH(1,INDEX((Booking!$C$1:$C$100=$E2)*(Booking!$B$1:$B$100>=Calls!$B2)*(Booking!$B$1:$B$100<=Calls!$D2),0),0)),"")

Regards
Bosco
 

Attachments

  • Calls Booking Example(1).xlsx
    13.3 KB · Views: 3
You must log in or register to reply here.
Back
Top