insert product into a timeline in a separate tab

[SteveCW]

Hi everyone! I am fairly new to excel and like with most things, I like to jump right in. I have identical product schedules in tab 1 and tab 2 (they are just formatted differently). I would like to auto populate the product name in the product column of tab 3 based on the beginning and end dates of the product campaign.
I'd really appreciate any and all help. I have tried nesting IF formulas, VLOOKUP, SUMPRODUCT, and others but to no avail. These functions will probably work but I may not applying them correctly.

[#2 · Accepted solution]

@SteveCW 

The Product column contains data validation that refers to an external workbook. I'd remove this.

Enter the following formula in  C2 on the '3' sheet:

=IFERROR(INDEX(Table34[product],MATCH(1,INDEX((Table34[start]<=[@Date])*(Table34[end]>=[@Date]),),0)),"")

Excel should automatically fill the entire Product column.

[#3]

Thanks Hans this works perfectly!