title: Paste Value all the cells in a given sheet if Cell has Vlookup formula..
body: <pre><code>=VLOOKUP(VALUE($B$100);INDIRECT("2011.xls!"&amp;D$101;0);3;0)
  </code></pre>
  
  <p>I have a sheet to send other people but i cannot send 2011.xls because it contains secret information. How can i copy-paste value all the cells in that sheet ("Centers") which has a formula like
       =VLOOKUP(VALUE($B$100);INDIRECT
  or contains VLOOKUP    ?</p>
  
  <p>Normally i would break link but because i have linked the table array with Indirect its not seen as a link</p>