Extracting data based on two helper column criteria

Good Afternoon,

I have a spreadsheet with two main worksheets - one titled "2018" which houses mainly a data dump of text information, and a "Dashboard" which I would like to be user-friendly. I had created a data extract to pull data from the "2018" worksheet to the "Dashboard" via numerical helper columns and IFERROR(INDEX()) formulas (see below):

=IFERROR(INDEX('2018'!$A$2:$M$18,'2018'!$I2,COLUMNS(B$6:$B6)),"")

This worked well but I realized that I need multiple drop downs to be able to whittle down the results, and I cannot get my formula correct. I have built two sets of helper columns C-E (for the year) and G-I (for the company).

What I am looking for -

To have data only pull into the Dashboard (cells B7:E7) when the resulting number is found in both H3 columns (columns E and I), and then to have the corresponding data (Month, Product, Action, Citations) from those row numbers pulled to the Dashboard.

I have attached an example file that functions with 1 criteria (Dummy1 drop down - located in cell B5), but does not work with both that and the year drop down (located in cell B4).

I hope that makes sense, and thank you in advance for any assistance you might be able to provide.

You've Excel 2016 so you can try PowerQuery aka Get&Transform

So I am trying to create two drop down, one for date and one for company which, when selected, will only pull over the information which matches both criteria. For instance, there are three records for Dummy5 company, 2 in 2018 and 1 in 2019. I want to be able to bring over information for Dummy5 company for all years (so all three records), and then also confine that information to just 2018 and/or just 2019. Does that help at all?

Thank you - I just got access to Excel 2016 so I'll have to play around with the PowerQuery features. I am not familiar SO I don't know if it will be able to accomplish what I am looking for, but I appreciate your suggestion.