Query on Vlookup/ VBA Macro


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:

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.




VLookup functions is not supported in the calculation engine. We will investigate and implement it. It will be available within one or two weeks.