Nested VLOOKUPs

4 posts, 0 answers
  1. Derek
    Derek avatar
    3 posts
    Member since:
    May 2016

    Posted 20 May 2016 Link to this post

    Good day,

    The spreadsheet control doesn't seem to support nested VLOOKUPS eg

    =IFERROR(IFERROR(VLOOKUP(alt_ref&"/"&supplierID&"/"&LEFT(courseCode,4)&"*",Calcs!A:G,6,FALSE),VLOOKUP(alt_ref&"/"&supplierID&"/",Calcs!A:G,6,FALSE)),VLOOKUP(alt_ref&"//",Calcs!A:G,6,FALSE))

    This works correctly in Excel.

     

    Regards

    Derek

     

  2. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2509 posts

    Posted 24 May 2016 Link to this post

    Hello Derek,

    I tried reproducing the problem in this sample Dojo snippet, and the VLOOKUP appears to be working as expected. Please modify the snippet so that it shows the problem, so that we can investigate.

    Regards,
    Alex Gyoshev
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Derek
    Derek avatar
    3 posts
    Member since:
    May 2016

    Posted 24 May 2016 in reply to Alex Gyoshev Link to this post

    Hi Alex

    It's probably easier if I give the actual excel spreadsheet I'm loading given that this is how the solution will operate. 

    On the 'Parameters' sheet you'll see 3 single VLOOKUPs and below those the nested equivalent. 

    I can see your example working and the only differences are that my formula is loaded from a spreadsheet rather that hard-coded Json and that I'm using named cells. very puzzling.

    Regards

    Derek

  4. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2509 posts

    Posted 26 May 2016 Link to this post

    Hello Derek,

    Thank you for the sample. We have reduced the sample and have logged it for fixing.

    Regards,
    Alex Gyoshev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top