VLOOKUP?

2 posts, 0 answers
  1. Guy
    Guy avatar
    18 posts
    Member since:
    Oct 2012

    Posted 31 Oct Link to this post

    Hi

    Using Telerik.Windows.Documents.Spreadsheet.Model.Workbook class, it seems there is no VLOOKUP function, although there is a LOOKUP function which works almost the same way. The lack of VLOOKUP specifically impacts my ability to load existing Excel documents. Is there a way to add a VLOOKUP function to the SpreadProcessing engine?

    Thanks,

    Guy

  2. Boby
    Admin
    Boby avatar
    595 posts

    Posted 01 Nov Link to this post

    Hi Guy,

    VLOOKUP function is currently not supported. I can see that you are already following the item in our feedback portal, so you'll get notified in case of status changes:
    Spreadsheet: Implement the VLOOKUP function

    There is API for adding custom functions, so you can try to implement it yourself. You can check the help article here: Custom Functions.

    Regards,
    Boby
    Telerik by Progress

Back to Top