This is a migrated thread and some comments may be shown as answers.

VLOOKUP?

4 Answers 454 Views
SpreadProcessing
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

4 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

0
Duncan
Top achievements
Rank 1
Iron
answered on 08 Aug 2021, 12:12 AM

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.

Dimitar
Telerik team
commented on 09 Aug 2021, 08:18 AM

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.

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