We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date


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.

1 Reply

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team February 22, 2023 12:25 PM UTC

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 support@syncfusion.com mentioning this forum ID.



Live Chat Icon For mobile
Up arrow icon