title: Index Match Where Clause Applies
body: <p>I want to return the value based on index/match where clause applies.</p>
  
  <p>==> Find barcode number where Price = 10 (this is variable) AND Flavour = Passion.</p>
  
  <p><strong>So far it returns only the barcode of the first row with "10" that it finds i.e. Barcode 1 instead of 2.</strong></p>
  
  <p>=IF(ISERROR(INDEX(F:F,MATCH(B2,I:I,0))),"",INDEX(F:F,MATCH(B2,I:I,0)))</p>
  
  <p><a href="https://i.stack.imgur.com/6PyAg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6PyAg.png" alt="Sample"></a></p>
  
  <p>Result so far:</p>
  
  <p><a href="https://i.stack.imgur.com/XrtHs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XrtHs.png" alt="enter image description here"></a></p>
  
  <p>Can someone advise?
  Thanks!</p>