Return dates from a list based on Month and Year cells

[rhaas128]

I have a workbook that has a defined list of months and years, along with a 2 different date columns that are not currently named. I need to be able to put a month/year on sheet1 from dropdown lists, and have the corresponding dates populate from those 2 different columns. Below is a sample idea of what I currently have:

Main table:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month(Dropdown)[/TD]
[TD]Year(Dropdown)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Datecol1[/TD]
[TD]Datecol2[/TD]
[/TR]
</tbody>[/TABLE]

Date column table:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Datecol1[/TD]
[TD]Datecol2[/TD]
[/TR]
[TR]
[TD]07/20/2018[/TD]
[TD]07/27/2018[/TD]
[/TR]
[TR]
[TD]08/03/2018[/TD]
[TD]08/10/2018[/TD]
[/TR]
[TR]
[TD]08/17/2018[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


So if I choose 'August' and '2018' from the main table, it would return results like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]August[/TD]
[TD]2018[/TD]
[/TR]
[TR]
[TD]08/03/2018[/TD]
[TD]08/10/2018[/TD]
[/TR]
[TR]
[TD]08/17/2018[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Can someone help me achieve this? Hopefully my goal makes sense. Thanks for all help in advance!

 

[jorismoerings]

Hi,

Take a look if this helps:

Book1
	A	B	C
1	Main table:
2
3	Month(Dropdown)	Year(Dropdown)
4	8	2018
5
6
7	Date column table:
8	Datecol1		Datecol2
9	20-7-2018		27-7-2018
10	3-8-2018		10-8-2018
11	17-8-2018
12
13	Selector
14	Month	Year
15	8	2018
16	Result
17	Datecol1		Datecol2
18	3-8-2018		10-8-2018
19	17-8-2018
Sheet1

Cell Formulas
Range	Formula
A18	{=IFERROR(INDEX($A$8:$A$11, MATCH(0, COUNTIF(A17:$A$17, $A$8:$A$11)+IF(MONTH($A$8:$A$11)<>$A$15, 1, 0)+IF(YEAR($A$8:$A$11)<>$B$15, 1, 0), 0),1), "")}
C18	{=IFERROR(INDEX($C$8:$C$11, MATCH(0, COUNTIF(C17:$C$17, $C$8:$C$11)+IF(MONTH($C$8:$C$11)<>$A$15, 1, 0)+IF(YEAR($C$8:$C$11)<>$B$15, 1, 0), 0),1), "")}
Press CTRL+SHIFT+ENTER to enter array formulas.