XlsIO XLOOKUP Formula

[Sam Haekens]

I have a workbook with a mainsheet ("OverzichtJumbo") and multiple other sheets which I need to get some data from.

I'm trying to use the formula XLOOKUP to get this data, formula works when I try it in Excel directly, but it gives me following error:

" Error: Syncfusion.XlsIO.Implementation.Exceptions.ParseException: XLOOKUP isn't custom function. at position 1. Formula: XLOOKUP(OverzichtJumbo!$A2;FirstTab!$A:$A;FirstTab!$B:$B;na;0;1), Position: 8 "

To add the formula to the sheet I use following code:

worksheetOverzicht.Range[$"C{count}"].Formula= $"=XLOOKUP(OverzichtJumbo!$A{count};FirstTab!$A:$A;FirstTab!$B:$B;na;0;1)"; 

Am I doing something wrong here or do I need a different approach if I want to use the XLOOKUP formula?

Thank you for the help.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Sam,

We request you to share the input Excel document and issue reproducing sample and confirm the Syncfusion XlsIO version you are using at your end, to investigate the query.

If you are not comfortable sharing those details here in public, please e-mail them to [e-mail] mentioning this forum ID.

Regards,

Keerthi.