insert product into a timeline in a separate tab

New Contributor

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 Replies
best response confirmed by SteveCW (New Contributor)


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:




Excel should automatically fill the entire Product column.

Thanks Hans this works perfectly!