How do I import data from another sheet and then filter it based on 2 different variables?
<p>I have been working on how I budget and keep track of my finances. In the process, I put together <a href="https://docs.google.com/spreadsheets/d/1_GGgFCfMtB5ROkTmpx4Fn4nZZbBIvBa4vpOwqswH5E0/edit?usp=sharing" rel="nofollow">this Google Sheet</a> which I am happy to share a dummy version of (includes dummy data).</p>

<p>I use a Google Form to input new entries which are recorded in the 'Log' page.</p>

<p>From here, I use a few SUMIFS to pull in the totals of any given income/expense category based on the category name (referenced in the cell adjacent), the month (B3), and the year (C3).</p>

<p>What I now want to do is add a table (currently in columns O:Q) that calls in itemised log records based on the category selected (O2) and the month and the year. On the reference sheet these are cells (B3) and (C3) respectively and in the log, these are columns (F) and (G). </p>

<p>I've gotten as far as using an INDEX / SMALL array formula combination to pull in all spending as per the category selected in (O2), but what I cannot seem to figure out is how to then restrict results to only those that also match the month and year. I've tried using a MATCH formula but am unsure how to append this within the current formula string, if it is even possible?</p>

<p>Once working, this would (for example) mean that only rows 4 and 5 in columns O, P, and Q would be populated as these are the records for the selected month, June 2016.</p>

<p>Is what I want to do possible through a more complex formula? Can anybody help?</p>

<p>Thank you in advance.</p>

<p>Link to my Google Sheet: <a href="https://docs.google.com/spreadsheets/d/1_GGgFCfMtB5ROkTmpx4Fn4nZZbBIvBa4vpOwqswH5E0/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1_GGgFCfMtB5ROkTmpx4Fn4nZZbBIvBa4vpOwqswH5E0/edit?usp=sharing</a></p>