title: MS Excel: IF and AND nested
body: <p>Can someone help with simple excel look up function: How can I pull assigned doctors from the table?</p>
  
  <pre><code>        All other cities
          and countries       Chicago   Boston    Atlanta   California   Dallas
  
  General     Lee               John
  
  Pediatrics  Greg
  
  Dermatology Greg                       Peter      Lee
  
  Optholmol   Greg
  
  Radiology   Mary
  
  Surgery     Greg                                            Mary         Greg
  </code></pre>
  
  <p>For ex., Dermatology and Boston should return Peter, but Dermatology from any other city should return Greg</p>