Using Index Match with a Criteria to return a minimum

Please Login or Register  to view this content.

Hi guys,

I have three columns of data: A: Site, B: Calls, C: Dollars. Let's say each column has 9 data entries.

In enlglish, this is what I am trying to achieve. Return the name of the site that has the minimum dollars, as long as that site takes at least x amount of calls. If it does not take at least x amount of calls, return the name of the site with the next smallest dollar amount. To put it another way, only consider sites that take at least x amount of calls.

Right now, this is where I am at. I am able to return the name of the site with the minimum dollars no problem, but am having trouble inserting in the "if the site takes at least x amount of calls" part.

Please Login or Register  to view this content.

Please let me know if you need any further clarification of my problem.

Thanks in advance!

David

No duplicate sites. Unique site in each row.

I actually was able to figure this out.

Please Login or Register  to view this content.

And made it an array formula.

Thanks!