title: Copy & Paste values if cell value = "N/A"
body: <p>I want to copy and paste values to a range of cells but only if their value = "N/A". I want to leave the formulas as they are in all the cells that do not = "N/A".</p>
  
  <p>In context, I have hundreds of VLOOKUPs. Example:</p>
  
  <pre><code>=IFERROR(VLOOKUP("L0"&amp;MID(G$4,1,1)&amp;"A0"&amp;MID(G$4,1,1)&amp;MID(G$4,3,2)&amp;"-0"&amp;$B6,Sheet1!$C:$D,2,FALSE),"N/A")
  </code></pre>
  
  <p>Is this possible with VBA?</p>