title: Fuzzy match on google sheets
body: <p>I'm trying to fuzzy match two columns in google sheets, i've tried numerous formulas but I think it's going to come down to a script to help out.</p>
  
  <p>I have a column with product ID's e.g. </p>
  
  <ul>
  <li>E20067</li>
  </ul>
  
  <p>and then I have another sheet with another column which has image url's relating to this product code such as</p>
  
  <ul>
  <li><a href="http://wholesale.test.com/product/E20067/web_images/E20067.jpg" rel="nofollow noreferrer">http://wholesale.test.com/product/E20067/web_images/E20067.jpg</a></li>
  <li><a href="http://wholesale.test.com/product/E20067/high_res/E20067.jpg" rel="nofollow noreferrer">http://wholesale.test.com/product/E20067/high_res/E20067.jpg</a></li>
  <li><a href="http://wholesale.test.com/product/E20067/high_res/E20067-2.jpg" rel="nofollow noreferrer">http://wholesale.test.com/product/E20067/high_res/E20067-2.jpg</a></li>
  </ul>
  
  <p>What I'm wanting to do is "fuzzy" match both of these columns for their product ID, and then create a new column for each match. So it would have the product ID then on the same row in multiple columns each product image URL - like the image below:</p>
  
  <p><a href="https://i.stack.imgur.com/uOnQf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uOnQf.png" alt="enter image description here"></a></p>
  
  <p>Is there a way to do this in google sheets using a script or a formula?</p>