Urgent Help !!

[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/1drG...ew?usp=sharing


Thanks,

Haider

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1094933-help-required-post5263312.html#post5263312

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).