Completed
Last Updated: 31 Oct 2018 07:50 by ADMIN
ADMIN
Anna
Created on: 22 Jul 2014 09:05
Category: Spreadsheet
Type: Feature Request
15
Spreadsheet: Implement the VLOOKUP function
VLOOKUP function is similar to LOOKUP function, which is currently supported.

A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions

This function can be implemented as a custom function. Check the following resources for more details on how to achieve that:

- http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions
- https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/CustomFunctions

Available in R3 2017 Official Release Version.
(Total attached files size should be smaller than 20mb. Allowed extensions: .zip, .rar, .jpg, .png, .gif)
2 comments
MikeWiese
Posted on: 17 Mar 2017 03:48
We need this. Can't import real-world spreadsheets without it. 

Also need Match and IfError
ADMIN
Tanya
Posted on: 21 Mar 2017 16:41
Hi Mike,

As we discussed in the forum post ( http://www.telerik.com/forums/iferror()-and-match() ), you can implement this function as a custom function. Please, refer to the description of this item for more details on how to achieve this.

Regards,
Tanya