title: VLOOKUP_ADD_Array Apache POI
body: <p>I'm using Apache POI to parse an excel document.</p>
  
  <p>It works fine until I reach a cell whom has a VLOOKUP_ADD_ARRAY.</p>
  
  <p>What my code does is:</p>
  
  <pre><code>XSSFWorkbook workbook = new XSSFWorkbook(httpOrder.getFile());
  XSSFSheet sheet = workbook.getSheet("MySheet");
  
  Iterator&lt;Row&gt; rowIterator = sheet.iterator();
  
  while (rowIterator.hasNext()) {
  
     Row row = rowIterator.next();
  
     Iterator&lt;Cell&gt; cellIterator = row.cellIterator();
  
     while (cellIterator.hasNext()) {
  
        Cell cell = cellIterator.next();
  
        switch (cell.getCellType()) {
  
        case Cell.CELL_TYPE_FORMULA:
          CellValue value = workbook.getCreationHelper().createFormulaEvaluator().evaluateFormulaCell(cell)
          break;
        }
  
     }
  
  }
  </code></pre>
  
  <p>I'm getting the following error: org.apache.poi.ss.formula.FormulaParseException: Name 'VLOOKUP_ADD_ARRAY' is completely unknown in the current workbook</p>
  
  <p>Can anyone help on this?</p>