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
3 Answers, 1 is accepted
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
Rank 1
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
Hello Derek,
Thank you for the sample. We have reduced the sample and have logged it for fixing.
Regards,Alex Gyoshev
Telerik