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
4 Answers, 1 is accepted
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
Rank 1
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
Rank 1
Iron
Yes, look at QVLOAD.
The VLOOKUP function is usually used for matching data from a table on the left side of the formula with data that exists in cell range on the top rows of a table on the right. Tables are typically located directly below one another and use the same number format as they have in Excel. It's also possible to provide a third column for further qualification or narrowing down, but if you're just performing an exact match, all it takes is two columns to pull what you're looking for.
A simple vlookup function for excel can be found at the following website here.
Thank you for sharing the details. I am sure someone will benefit from this.
I want to say that the VLOOKUP function is now supported in our library out of the box.