Assigning value based on date range & another criteria

[emshep005]

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:

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!

 

[Gerald Higgins]

Hi.
What should the results be for your two examples ?
For Brand A, I'm guessing "Winter Clearance".
For Brand B, I'm guessing "Summer"

Is that right ?

More generally, is it possible that the dates for any event, for any brand, could overlap with the dates for another event, for the same brand ?

And also, is it possible that an "Actual Date" could be in a period where there is no event on for that brand ?
If yes, how do you want to handle that ?

 

[emshep005]

Hi,

Brand A would fall under Athletic & Brand B would fall in Summer.

There are never any days that would not be part of an event. There are also never days that overlap.

Thanks!

 

[emshep005]

This is solved. I accidentally posted twice. Thank you though for your help!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1079273-need-help-vlookup-2-criteria.html#post5185439