title: Convert Excel Array to VBA
body: <p>I'm trying to convert an excel array to VBA. Any help would be appreciated:</p>
  
  <pre><code>{=IFERROR((MATCH('Surgery'!D10&amp;'Surgery'!D11,'NCCI'!A1:A263469&amp;'NCCI'!B1:B263469,0)),"")}
  </code></pre>
  
  <p>The Surgery worksheet is where the user inputs a list of codes and the NCCI worksheet is where the above array searches to find a match. It uses the two codes entered by the user to search in two columns on the NCCI worksheet to try and find where two codes are in the same row and returns the row number.</p>