title: Excel - Entering Too many Argument on an IF AND Function
body: <p>Excel is throwing an error with my formula:<br>
  <strong><code>You have entered too many arguments for this function.</code></strong></p>
  
  <blockquote>
    <p>IF(AND(J2="Ounces",K2&lt;=5),VLOOKUP(D2,'Parcel Select oz Lightweight'!$A$2:$B$17,2,0),IF(AND(J2="Ounces",K2>5),VLOOKUP(D2,'First Class oz'!$A$2:$B$17,2,0)),IF(AND(J2="Pounds",K2&lt;=5),INDEX('lb and zones select'!$A$2:$K$73,MATCH(D2,'lb and zones select'!$A$2:$A$73,0),MATCH(H2,('lb and zones select'!$A$2:$K$2))),IF(AND(J2="Pounds",K2>5),INDEX('lbs and zones priority'!$A$2:$K$73,MATCH(D2,'lbs and zones priority'!$A$2:$A$73,0),MATCH(H2,'lbs and zones priority'!$A$2:$K$2,0)))))</p>
  </blockquote>
  
  <p>I know its a really ugly formula.</p>