title: Converting Excel formula to VBA add-in (FILTER)
body: <p>I have this formula in a cell, it effectively works a bit like xlookup but actually returns all the matches as a CSV string instead of just the first match</p>
  <p>=TEXTJOIN(&quot;, &quot;,TRUE,FILTER('[myFile.xlsx]ForLookUp'!$K:$K,'[myFile.xlsx]ForLookUp'!$N:$N=A2))</p>
  <p>Where</p>
  <ul>
  <li>Column K is where the returned values will be pulled from,</li>
  <li>Column N is where the data range to find matches in lives</li>
  <li>and A2 is the cell that contains the 'key' I'm trying to match</li>
  </ul>
  <p>This works fine but I want to convert it to VBA so I can add it to my Add-In file and reuse</p>
  <p>I thought it was going to be relatively simple but I don't think either TEXTJOIN or FILTER exist as-is in VBA? I've been around the web trying to find answers but have not ready found something which works for me.</p>
  <p>Ideally for the add-in, both the ranges and the key would be params passed to the routine. Any help would be much appreciated.</p>
  <p>Regard</p>