Hi,
Hopefully someone can help me. I have a chart that lists dates of two brands and some events that run each year for past 2 years.
In another tab I have a list of dates between the two brands. I want to first, identify the brand, then if the date falls between the date ranges of a certain event and if it does, return that event's name.
Here is a snapshot:
Here is an example of what I want to find:
Let me know if I should post in a different way. Thanks everyone!
Hopefully someone can help me. I have a chart that lists dates of two brands and some events that run each year for past 2 years.
In another tab I have a list of dates between the two brands. I want to first, identify the brand, then if the date falls between the date ranges of a certain event and if it does, return that event's name.
Here is a snapshot:
Brand (Column A) | Event (Column B) | start (Column C) | end (Column D) |
Brand A | Winter Clearance | 1/1/2017 | 2/7/2017 |
Brand A | Athletic | 2/8/2017 | 3/28/2017 |
Brand B | Spring | 3/29/2017 | 5/23/2017 |
Brand B | Summer | 5/24/2017 | 6/20/2017 |
Brand A | Summer Clearance | 6/6/2018 | 7/10/2018 |
Brand A | Black Friday/Cyber Monday | 11/14/2018 | 11/27/2018 |
Brand A | Holiday | 11/28/2018 | 1/1/2019 |
Brand B | Spring | 3/14/2018 | 5/8/2018 |
Brand B | Summer | 5/9/2018 | 6/19/2018 |
Here is an example of what I want to find:
Brand | Actual Date | Event |
Brand A | 3/15/2017 | ? |
Brand B | 5/18/2018 | ? |
Let me know if I should post in a different way. Thanks everyone!