VLOOKUP returns #N/A

[Matthew Smith]

I am trying to import the data from a spreadsheet which has columns that use VLOOKUP. I am able to detect the formula and have enabled sheet calculations. However, the calculated value that is return is #N/A. The documents states VLOOKUP is supported yet I cannot get back the correct text displayed in the actual spreadsheet when viewed in Excel.

Does VLOOKUP actual work within XlsIO?  

[Abirami Varadharajan]

Hi Matthew, 

 

Greetings from Syncfusion. 

 

Yes, VLOOKUP is supported in XlsIO. We are unable to reproduce the issue and we suspect that the issue occurs with specific document/formula. 

 

We are sharing the sample which we have tried at our end for your reference which can be downloaded from following link. 

 

Sample Link:  https://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample1505392502.zip  

  

Please modify the sample to reproduce the issue and get back to us with an issue reproducing sample which will be helpful for us to analyse further and to provide prompt solution.  

 

Regards, 

Abirami 

[Matthew Smith]

Abirami,

Sorry for the delay. I found the route cause of why the VLOOKUP was not working within XlsIO.

The target spreadsheet is version of a Google Spreadsheet which was linked to a external data source. The cell which the VLOOKUP was referencing which was in a separate workbook in the spreadsheet had a formula like this:

=IFERROR(__xludf.DUMMYFUNCTION("""COMPUTED_VALUE"""),"R5 Disc Red eTap")

I think this is the reason why the VLOOKUP failed and returned NULL.

[Abirami Varadharajan]

Hi Matthew, 

Thank you for updating us. 

We are getting incorrect calculated value(i.e., #VALUE!) is returned for the cell which has VLOOKUP formula and referring the external workbook. Also, we are not getting the calculated value as #N/A or null as per your update.  

However, the issue has been resolved in our release version 16.3.0.21. You can also refer the latest NuGet from following link to your application to ensure the same.    

https://www.nuget.org/packages/Syncfusion.XlsIO.WinForms/ 

Please find the sample which we have tried at our end. 

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample-752405242.zip  

If your scenario from this or the issue reproducing with latest NuGet, kindly modify the sample to reproduce the issue and get back to us with an issue reproducing sample which will be helpful for us to provide prompt solution at the earliest. 

Regards, 

Abirami