Why won't my formula update??

excelhelp213

New Member
Joined
Jun 14, 2016
Messages
2
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
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
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.
 
Upvote 0

Forum statistics

Threads
1,226,730
Messages
6,192,711
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top