VLOOKUP?

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

    Posted 31 Oct 2016 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
    620 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.

    Regards,
    Boby
    Telerik by Progress

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

    Posted 16 Mar 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
    Admin
    Tanya avatar
    516 posts

    Posted 21 Mar 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()

    Regards,
    Tanya
    Telerik by Progress

Back to Top