title: Formula for EXCEL - INDEX MATCH, LARGE and MULTIPLE CRITERIA
body: <p><a href="https://i.stack.imgur.com/qJv0D.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qJv0D.png" alt="enter image description here" /></a></p>
  <p>Is there a function to INDEX, MATCH, based on the criteria that the select Fruit is &quot;TRUE&quot;, based on how LARGE their sales number is?</p>
  <p>I've tried AGGREGATE, and multiple solutions, but I cannot find one that effectively matches the LARGEST based on the criteria that it is true.</p>
  <p>Appreciate any help. Thank you.</p>