I need help with a formula to look in a chart & (1) identify brand, (2) determine if a date is between to dates, and (3) return a value of a corresponding event. Here is a snapshot of the data:
<tbody>
</tbody>
Here is what I'm looking for:
<tbody>
</tbody>
So this first one for Brand A 3/15/17 should return event: Athletic
Brand B 5/18/18 should return event: Summer
Thank you!!!
Brand (Col. A) | Event (Col. B) | start (Col. C) | end (Col. 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 | 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 |
<tbody>
</tbody>
Here is what I'm looking for:
Brand | Actual Date | Event |
Brand A | 3/15/2017 | ? |
Brand B | 5/18/2018 | ? |
<tbody>
</tbody>
So this first one for Brand A 3/15/17 should return event: Athletic
Brand B 5/18/18 should return event: Summer
Thank you!!!