This is a migrated thread and some comments may be shown as answers.
VLOOKUP?
3 Answers 33 Views
This is a migrated thread and some comments may be shown as answers.
Guy
Top achievements
Rank 2
Guy asked on 31 Oct 2016, 09:33 AM

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

3 Answers, 1 is accepted

Sort by
0
Boby
Telerik team
answered on 01 Nov 2016, 11:57 AM
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

0
MikeWiese
Top achievements
Rank 1
answered on 17 Mar 2017, 03:50 AM
I see this has been on your todo list since 22 July 2014. Any idea when it might be implemented?
0
Tanya
Telerik team
answered on 21 Mar 2017, 04:43 PM
Hi Mike,

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

Regards,
Tanya
Telerik by Progress

Asked by
Guy
Top achievements
Rank 2
Answers by
Boby
Telerik team
MikeWiese
Top achievements
Rank 1
Tanya
Telerik team
Share this question
or