title: how to get third column value fulfilling two conditions?
body: <p>I am working on an <strong>excel data sheet</strong>. In that i want to get the third column value fulfilling the conditions for first two columns.My sample data plan is as below :</p>
  
  <pre><code>    |   A   |   B   |   C
  1   |   ID1 |   ID2 |   VALUE
  2   |    AA |    CC |   14
  3   |    BB |    AA |   24
  4   |    CC |    DD |   15
  5   |    DD |    AA |   13
  6   |    BB |    CC |   8
  7   |    AA |    BB |   21
  8   |    DD |    BB |   11
  9   |    CC |    AA |   16
  10  |    DD |    CC |   26
  11  |    BB |    DD |   15
  12  |    CC |    BB |   14
  13  |    AA |    DD |   19
  </code></pre>
  
  <p>Now I want the <strong>value</strong> when <strong>ID1</strong> is say <strong>"BB"</strong> and <strong>ID2</strong> is say <strong>"DD"</strong> in any arbitrary cell so the value <em><strong>15</strong></em> should be displayed in that cell. and this could be used for <strong>any value of ID1 and ID2</strong> and the corresponding value in third column is to be be displayed.</p>
  
  <p>Please help me if you know...and I prefer to use the <em>formulas</em>, not the <em>macro coding</em> although we required to use more than one formulas or complex formulas.  </p>