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:

Month(Dropdown)	Year(Dropdown)
Datecol1	Datecol2

<tbody>
</tbody>

Date column table:

Datecol1	Datecol2
07/20/2018	07/27/2018
08/03/2018	08/10/2018
08/17/2018

<tbody>
</tbody>

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

August	2018
08/03/2018	08/10/2018
08/17/2018

<tbody>
</tbody>

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.