We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Vlookup formula not calculate

Hi Team,

I have one column having Vlookup formula which is not calculating or refreshing value.
You can check “Imbalance_check_data” sheet for “AR” and “AS” column in VLookupIssue1.xlsx file.

VLookupIssue1.zip (4.1 MB)

Similar issue of VLookup formula for another excel VLookupIssue2.xlsx file for “Report” sheet in “B” column.VLookupIssue2.zip (33.1 KB)

Both the file I attached.
In both the scenario, we are copying data from database and pasting in excel. And then we expect Vlookup to calculate value based on dataset, but it failed to calculate value.

Can you have a look and replay ASAP.


You may share your runnable sample console application which can be compiled and executed here without any missing reference including the required data. We will reproduce this issue here and provide assistance accordingly.

We found in VLookupIssue2.xlsx the range of table “i_TPPR_REPORT” is incorrect. It should be $A$4:$I$73 but now it is only $A$4:$I$4. You should check your application of creating this file(filling data) to expand table range correctly.