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.
Bookmarks