title: If cell matches any others in range copy content to "results" sheet
body: <p>I want to check if the text in A3 matches the text in any other cells in range A5:A50.</p>
  
  <p>If it does I want to copy the contents of the Y cell (with the same row number as the a cell that matched A3) into the next free cell in the A column in a sheet called results. It needs to also keep the cell colour when it copies the Y cell.</p>
  
  <p>All I could get was putting this in the destination cell</p>
  
  <pre><code>= VLOOKUP(Sheet1!A3, Sheet1$A$5:$Y50, 25, TRUE) 
  </code></pre>
  
  <p>That doesn't work as I need to run it over multiple sheets all with different names. </p>