title: Setting a cell to a value of another cell IF another cell was value X
body: <p>Is there a formula in excel to allow you to obtain the value of another cell WHEN a second cell was value X?</p>
  
  <p>For example, something like:</p>
  
  <pre><code>=GETWHEN(A1,3,B2)
  </code></pre>
  
  <p>Which would return B2's cell value when A1 is value 3.</p>
  
  <p>So if let's say you had a cell B2=4*B1. And B1 you set to 3, so B2 would show 12. But I want to make a row of entries to plot what B2 will be when A1 is 1, 2, 3, 4, 5 etc...</p>
  
  <p><img src="https://i.stack.imgur.com/yNhiC.png" alt="http://i44.tinypic.com/21eua80.png"></p>
  
  <p>What could I put under A1 Values?</p>
  
  <p>EDIT: I'm not looking for a if like in the conditional sense. I'm looking for the value WHEN (edited now)</p>