title: Load n Record of Spreadsheet where parameter matches
body: <p>Working in Microsoft Excel, I have a spreadsheet with the equivalent of a shopping list, if the Quantity is greater than 0 then I wish to display the description on another sheet. </p>
  
  <p>This is something that is quite simple using the INDEX function, however this only returns the first value that matches. </p>
  
  <p>How should I re-factor the query below, to return the value of (n)</p>
  
  <p><code>=INDEX(Software!B23:Software!B34,MATCH(TRUE,INDEX(Software!A23:Software!A34&lt;&gt;0,0),0))</code></p>
  
  <p>Having assumed this to be an array, I mistaking thought I could call Array[n] for the location, however this has proven incorrect.</p>
  
  <p>Thank you for your assistance. </p>