title: How to combine two or more formulas into one cell but if one condition is true that result i should get
body: <p>In Below Code, If I use <strong>OR</strong> Condition it will work, but I don't know how to use OR condition.    </p>
  
  <p><code>=IF(AND(K2="Quality Healthcare"),VLOOKUP(L2,Dropdown!E80:F84,2,0)),IF(AND(K2="Sky Lakes Medical Center"),VLOOKUP(L2,Dropdown!E80:F84,2,0))</code></p>
  
  <p>Please help on this, Thanks.</p>