4 posts, 0 answers
  1. Guy
    Guy avatar
    21 posts
    Member since:
    Oct 2012

    Posted 31 Oct 2016 Link to this post


    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?



  2. Boby
    Boby avatar
    645 posts

    Posted 01 Nov 2016 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.

    Telerik by Progress

  3. MikeWiese
    MikeWiese avatar
    43 posts
    Member since:
    Apr 2007

    Posted 16 Mar 2017 Link to this post

    I see this has been on your todo list since 22 July 2014. Any idea when it might be implemented?
  4. Tanya
    Tanya avatar
    623 posts

    Posted 21 Mar 2017 Link to this post

    Hi Mike,

    I just posted a reply in the forum thread you started, discussing the MATCH, IFERROR and VLOOKUP functions. Please, check the answer there: http://www.telerik.com/forums/iferror()-and-match()

    Telerik by Progress

Back to Top