title: Why am I getting the error - Too many arguments from this formula?
body: <p>I am trying to create a macro for the following formula. First though, I need to get the formula working when referencing a spreadsheet saved separately on the hard drive. Below is what I have but I am getting the error of <strong>Too many arguments</strong>.</p>
  
  <pre><code>=IFERROR(IF(C2&lt;&gt;"",IF(AND(VLOOKUP(A2&amp;"",[LPSMatch.xlsx]Sheet1!$A:$B,2,FALSE)="Assigned Attorney",OR(B2="Jimmy Edwards",B2="Kathleen McCarthy")),"Sales Team",IF(AND(VLOOKUP(A2&amp;"",[LPSMatch.xlsx]Sheet1!$A:$B,2,FALSE)="Intake Team, Assigned Attorney, or Sales Team",B2&lt;&gt;"Jimmy Edwards",B2&lt;&gt;"Kathleen McCarthy"),B2,IF(AND(VLOOKUP(A2&amp;"",[LPSMatch.xlsx]Sheet1!$A:$B,2,FALSE)="Intake Team, Assigned Attorney, or Sales Team",OR(B2="Jimmy Edwards",B2="Kathleen McCarthy")),"Sales Team",IF(VLOOKUP(A2&amp;"",[LPSMatch.xlsx]Sheet1!$A:$B,2,FALSE)="Assigned Attorney",B2,IF(AND(VLOOKUP(A2&amp;"",[LPSMatch.xlsx]Sheet1!$A:$B,2,FALSE)="Sales Team",OR(B2="Jimmy Edwards",B2="Kathleen McCarthy")),"Sales Team",IF(C2&lt;&gt;"",VLOOKUP(A2&amp;"",[LPSMatch.xlsx]Sheet1!$A:$B,2,FALSE),"INTAKE TEAM")))))), VLOOKUP(A2&amp;"",[LPSMatch.xlsx]Sheet1!$A:$B,2,FALSE),"")
  </code></pre>
  
  <p>Any help? When I go to the function help all of the arguments are okay but it highlights the "" at the end of my formula.</p>