It looks like the LOOKUP formula is supported in the .NET version of Aspose.Cells but not in the Java version. By any chance, do you have plans about this formula and any future support ?
Thanks for considering Aspose.
Well, VLOOKUP is supported in Aspose.Cells for Java and it works fine as I tested with the component.
Which version of the product you are using? kindly try the latest version (1.9.2).
If you still find the problem, please post your template file with sample code here, we will check it soon.
Thanks for your answer.
I have noted that the VLOOKUP formula is supported. But my user would have liked to use the LOOKUP formula, which is not. He worked around this issue by not using it…
For the record, I have tested it with the 1.9.2 version for jdk 1.5.
We will support LOOKUP function in our future version soon.