Hi -
I tried using Vlookup API function using Aspose.Excel for .net, i always get a return value "0" after calculating the formula at run time which is not correct. The same formula works if i apply directly in spreadsheet.
Below are the product details i work with
Aspose Version: 3.5.1.0
Excel Version: 2000
I used licenced version that to i believe it is Enterprise edition.
Attached below is the excel file with .net soln i tested.
I already sent the same content to this email nanjing@aspose.com. which i got from forum.
Any help with quick turnaround is greatly appreciated.
Thanks
-Bala