Multiple Matching Data returns values
<p>2 large data sets which one is for import into program (worksheet 2), worksheet 2 is for easy modifications.</p>

<p>what formula can be used to copy qty's in worksheet 2 to qty's in worksheet 1 if code 1 and code 2 ranges match.</p>

<p>WORKSHEET 1 </p>

<pre><code>code 1  Description      code 2 QTY
ITEM1   EXAMPLE          100    
ITEM1   EXAMPLE          200    
ITEM1   EXAMPLE          A  
ITEM1   EXAMPLE          B  
ITEM1   EXAMPLE          C  
</code></pre>

<p>WORKSHEET 2                             </p>

<pre><code>CODE 2  100 200 A   B   C   D
CODE 1  Description                                                                 
ITEM 1  EXAMPLE QTY   20    25  50  100 2   35
</code></pre>

<p><a href="https://i.stack.imgur.com/Hogpv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Hogpv.png" alt="Example"></a></p>