Quicker way to filter out data based on a particular value <p>I am working with a workbook that currently has 3 sheets. The first sheet is an overview where the filtered data will appear. Cell <code>D11</code> has the color that I am looking for. Upon entering the color cells <code>F3:I27</code> Populate with information like color, shape, number and animal.</p> <p><a href="http://1drv.ms/1HE5PLr" rel="nofollow">C2C-Tracker2</a></p> <p>I would use a Pivot Table for this, however, I have another set of data in <code>K3:M27</code>. This data is pulled from another sheet within the workbook with a similar function.</p> <p>The formula that I am using is:</p> <pre><code>=IFERROR(INDEX(cases!A:A,SMALL(IF(EXACT($D$3,cases!$C:$C),ROW(cases!$C:$C)-ROW($F$1)+1),ROW(1:1))),"") </code></pre> <p>Of course it is entered using <kbd>CTRL</kbd> + <kbd>SHIFT</kbd> + <kbd>ENTER</kbd> for it to work properly.</p> <p>I tried using a VBA Macro that I pulled from the video below:</p> <p><a href="https://youtu.be/QOxhRSCfHaw" rel="nofollow" title="VBA Extract Data">Excel VBA Loop to Find Records Matching Search Criteria</a></p>