BoldSignA modern eSignature application with affordable pricing.
Sign up today for unlimited document usage!
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:
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.
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 firstname.lastname@example.org
mentioning this forum ID.