Why won't my formula update??

[excelhelp213]

Hi,

I'm creating a sheet that ranks vendors by cost. I have a table below the cost/ranking table where I want to display the preferred carrier name.

I'm using index and match in this formula, but it isn't updating as filters are adjusted.
For example:
If the Equip Type is filtered to "B", the preferred contact is displaying as "M" in that table. This is correct, M is the highest ranked vendor for this example. But, if you filter specialty to "YES", the preferred contract is displayed as "D". D isn't an option under these filters and the highest ranking should still be for M.

The link to the sheet is below, any help is desperately needed and would be very much appreciated!!

https://drive.google.com/file/d/0B9E2XetgXBGOMzBFdnJUajZ2U0k/view?usp=sharing

 

[Roderick_E]

I can't look at your example from work but on first consideration, I suspect you are getting a skewed result because index/match doesn't just look at filtered.

 

[excelhelp213]

I can't look at your example from work but on first consideration, I suspect you are getting a skewed result because index/match doesn't just look at filtered.

That would make sense, any idea what I need to change in order to make it work correctly?