Index Match Returning Results for Filtered Out Data

I am using an Index/Match to get data from a related table to populate in the first table. In my related table I have filtered out values, but the filtered out values are still populating in my first table. If Index/Match is not smart enough to only grab the filtered values, how can I work around this (formula preferred, but VBA acceptable) to get only the filtered values.

Here's an example of one that mirrors by desired behavior, except you can see that if you filter the data, the summary still has all the data. While this is a macro driven worksheet and I have a straight index/match, you can still see the same issue of filtered data still showing.03_28_11.xlsm

Here's an example of one that mirrors by desired behavior, except you can see that if you filter the data, the summary still has all the data. While this is a macro driven worksheet and I have a straight index/match, you can still see the same issue of filtered data still showing.