title: ClosedXML System.Exception: Syntax error
body: <p>I am using ClosedXML to calculate values in excel sheet from user provided inputs and i am getting error on the cell containing following formula</p>
  
  <blockquote>
    <p>IF(C2=1,VLOOKUP(D7,A15:D28,4),(IF(C2=2,VLOOKUP(D7,A33:D46,4),VLOOKUP(D7,F15:I28,4))))</p>
  </blockquote>
  
  <p>On line:</p>
  
  <pre><code>lblResult.Text = worksheet.Cell("D8").Value;
  </code></pre>
  
  <p>Can you help me finding what's going wrong here? </p>
  
  <p>Thanks in advance </p>
  
  <p>Following is the stack trace
  Stack Trace: </p>
  
  <pre><code>[Exception: Syntax error.]
     ClosedXML.Excel.CalcEngine.CalcEngine.GetParameters() +223
     ClosedXML.Excel.CalcEngine.CalcEngine.ParseAtom() +141
     ClosedXML.Excel.CalcEngine.CalcEngine.ParseUnary() +77
     ClosedXML.Excel.CalcEngine.CalcEngine.ParsePower() +16
     ClosedXML.Excel.CalcEngine.CalcEngine.ParseMulDiv() +16
     ClosedXML.Excel.CalcEngine.CalcEngine.ParseAddSub() +16
     ClosedXML.Excel.CalcEngine.CalcEngine.ParseCompare() +16
     ClosedXML.Excel.CalcEngine.CalcEngine.Parse(String expression) +67
     ClosedXML.Excel.CalcEngine.ExpressionCache.get_Item(String expression) +140
     ClosedXML.Excel.CalcEngine.CalcEngine.Evaluate(String expression) +27
     ClosedXML.Excel.XLCell.get_Value() +411
     TestExcel.btnResult_Click(Object sender, EventArgs e) in f:\Projects\Generation Circuit\gencricuit\GenerationCircuit\TestExcel.aspx.cs:30
     System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9628026
     System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103
     System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
     System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
     System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724
  </code></pre>