title: Combining VLOOKUP, IF OR, and STDEV
body: <p>In Excel I have two columns. One has a player's name and the other has points scored. Like this:</p>
  
  <pre><code>Player  Points
  Foo     10
  Bar     11
  Foo     23
  Test    9
  Joe     1
  Foo     2
  </code></pre>
  
  <p>What I'm trying to do is get the standard deviation of the points for a combined list of players.</p>
  
  <p>For example, if I had this list:</p>
  
  <pre><code>Foo
  Bar
  </code></pre>
  
  <p>I would want the standard devation of 10, 11, 23, and 2, since those are the values that match those two players.</p>
  
  <p>I have tried this formula:</p>
  
  <pre><code>=STDEV(IF(OR(A:A="Foo",A:A="Bar"),B:B,""))
  </code></pre>
  
  <p>but I get a different answer than if I were to use the STDEV formula on the individual numbers that it should be using.</p>
  
  <p>Anyone know if this is possible? Thanks!</p>