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: 188.8.131.52
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 firstname.lastname@example.org. which i got from forum.
Any help with quick turnaround is greatly appreciated.