Nested VLOOKUPs

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

    Posted 20 May 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
    2500 posts

    Posted 24 May 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. UI for ASP.NET MVC is VS 2017 Ready
  4. Derek
    Derek avatar
    3 posts
    Member since:
    May 2016

    Posted 24 May 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

  5. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 26 May 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
UI for ASP.NET MVC is VS 2017 Ready