title: Excel Formula for match concatenate string with any value in cell > display this cell value
body: <p>I want a formula which will concatenate cell values plus several strings added by the user (i.e. I want to add a "/filepath/" and ".jpg") and check if that value is found in another column of cells.</p>
  
  <p>i.e. check <code>if "/filepath/images" + CellA1 + " (rear view).jpg"</code></p>
  
  <p>I have this </p>
  
  <p><code>=INDIRECT("A"&amp;(MATCH("*"&amp;LEFT(H18,32)&amp;"*",$A:$A,0)))</code></p>
  
  <p>but need to altered so that I can check a concatenate as opposed to a single cell value is found in row A.</p>