title: Excel textjoin filtered results from different sheet
body: <p>I have a tab, List_State_6.10.2022 that looks like this:</p>
  <pre><code>     A                    G         ...  J          ...  S
  1    Device    Org   ...  component ...  Display    ...  Comp+Display
       ABC123    co    ...  part1     ...  Not Found  ...  part1+Not Found
       ABC234    co    ...   part2    ...  ok         ...  part2+ok
       ABC123    co    ...   part3    ...  ok         ...  part3+ok
  </code></pre>
  <p>I have a FinalResult tab that is trying to do multiple lookups in this tab above to find states, and appending each one found for same device number into the same cell for w2.</p>
  <p>w2 should show: <code>part1+Not Found;part3+ok</code></p>
  <p>I got a working solution for Office365 in the following topic, however I'm using Excel 2016 and need a solution for that version.</p>
  <p><a href="https://stackoverflow.com/questions/70023831/excel-lookup-index-that-can-return-multiple-results">enter link description here</a></p>
  <p>Edit: removed questions about Excel versions.</p>