title: Using TEXTJOIN to concatenate, then IF, INDEX, MATCH to fetch data - only works when the number of 'textjoined' cells is small
body: <p>I have data spread out on rows (SKU#s) that relate to a part# on the same row.  I have TEXTJOINED the SKU# cells into one cell on each row.  Then, on another sheet I have a formula that uses IF, INDEX and MATCH to look at a SKU# next to it, then search for that SKU# in the textjoined cell and return the part#.  It works well as long as there aren't too many SKU#s textjoined together.  12 SKU#s works fine, 30 does not.  I have as many as 80 SKU#s on a row.</p>
  
  <p>I only know that one row of data that has 12 SKU#s works, but the rows with 30 or more SKU#s do not.  Unfortunately I don't have rows with say 15 or 20 so I can't determine exactly what the limit is.</p>
  
  <p>I should note that all of the textjoined cells have data in them - none of them have thrown up an error.</p>
  
  <p>The TEXTJOIN formula starting on row 5.</p>
  
  <pre><code>=TEXTJOIN(",",TRUE,H5:CI5)
  </code></pre>
  
  <p>The IF, INDEX &amp; MATCH formula starting on row 5.</p>
  
  <pre><code>=IF(LEN(A5)=8,INDEX('DEST MISMATCH'!$CO$3:$CO$5000,MATCH("*"&amp;A5&amp;"*",'DEST MISMATCH'!$CM$3:$CM$5000,0)),"")
  </code></pre>
  
  <p>What I need to have happen is for the formulas to work on up to 80 textjoined values (SKU#s).</p>