title: Excel table lookup matching values of two columns
body: <p>I'd like to create a table lookup formula that matches two columns.  For instance, suppose I'd like to find the value of the <code>Letter</code> column at the row where the <code>Type</code> column is <code>Biennial</code> and the <code>Result</code> column is <code>Warning</code>.</p>
  
  <p><PRE>
    A               B            C
  1 Letter          Type         Result
  2 A               Annual       Exceeds
  3 B               Biennial     Warning
  4 C               Biennial     DevelopmentNeeded
  5 D               Biennial     PartiallyMeets
  6 E               Annual       Meets
  </PRE></p>
  
  <p>What would the formula look like to accomplish this?</p>