Help Required

[fhaid]

Dear All

Need an urgent help to get the below scenario sorted.

I have attached 2 sets of Data.

In Sheet2, there is a TV Ad data aired on different channels. Explanation of each column below

Channel: Name of the Channel
Date: Current Date
AD Start: TV AD start Time
MidBreak: Tells about the Mid Break in an Hour. For e.g MidBreak-1, MidBreak-2, MidBreak-3, etc. etc.
Break Start and Break End: These columns tells about the Break time start and Break Time End in a prticular time slot.

In Sheet1, I need an output on New Time Column. This New Time column will populate from Sheet 2 through its Channel Name, Date and Time Slot. New Time column output would be any random time on a specific Channel, Date and Time Slot. I have mentioned few example in the below link in excel.

https://drive.google.com/file/d/1drGK3zzkT5c_axxpClunDRUaIYb8poUz/view?usp=sharing


Thanks,

Haider

 

[SpillerBD]

I do not see any unique correlation to get to example new-times.

 

[fhaid]

I do not see any unique correlation to get to example new-times.

The correlation is between Channel, Date and Time Slot. Basically in new time column, the output will come from Sheet2's ADStart column