title: How to make this match/index worksheetfunction as array formula?
body: <pre><code>matchRECORD1 = Application.WorksheetFunction.Index(Sheets("TEMPDB").Range("D" &amp; lrCHIMPORT2 + 1 &amp; ":D" &amp; lr3CHIMPORT2), _
                                      Application.WorksheetFunction.Match(Sheets("STATIONS").Cells(RARSTAT3, 2) &amp; Sheets("STATIONS").Cells(1, cARTIST), _
                                      Sheets("TEMPDB").Range("C" &amp; lrCHIMPORT2 + 1 &amp; ":C" &amp; lr3CHIMPORT2) &amp; Sheets("TEMPDB").Range("A" &amp; lrCHIMPORT2 + 1 &amp; ":A" &amp; lr3CHIMPORT2)))
  </code></pre>
  
  <p>How to make this like an array formula?</p>