title: How to use index match with IF in excel?
body: <p>Table1</p>
  
  <pre><code>   A         B            C            D   
  1 Seq        Item     Re-Order Qty  On-hand Qty
  2  1          X         10           15
  3  2          Y         10           5
  4  3          Z         10           10
  </code></pre>
  
  <p>Other worksheet:
  Table2</p>
  
  <p>Expected output:</p>
  
  <pre><code>    A           B            C
  1   Seq       Item      Re-Order Qty
  2   1          N/A          N/A
  3   2           Y           10
  4   3          N/A          N/A
  </code></pre>
  
  <p>In table2 I need to put in column 2 equation like this:</p>
  
  <pre><code>Index(Table1[Item],Match(table2[Seq],tabel1[Seq],0) WHERE table1[reorder qty] &gt; table1[On-hand Qty]
  </code></pre>
  
  <p>I'm not sure how such requirement could be managed?</p>