I am trying to use the following formula in my java program: cell.setCellFormula("VLOOKUP(A2, A1:Z2, 2, FALSE)"); The result of the above formula is #VALUE!. But if I replace the first argument of the vlookup with an actual value instead of cell reference it works fine. cell.setCellFormula("VLOOKUP(\"Test\", A1:Z2, 2, FALSE)");
Created attachment 11778 [details] VLookUp Error
Re-tested in 3.1-beta1. This was probably fixed in bug 44675 (second part - if the parameter operand class is wrong Excel evaluates VLOOKUP to '#VALUE!')