title: How to Make One Cell equal different cell values on multiple sheets and locations
body: <p>I'm working in Excel 2010, and my question is how do I make a cell (say on one sheet to equal a specific value placed on another sheet). I thought the following formula would do it but it doesn't work.</p>
  
  <pre><code>=IF(COUNTIF(Name,$A2)=1,VLOOKUP($A2,Name,2,FALSE),''))
  </code></pre>