I’m having a weird result coming out of the bumblebee read excel node.
As you can see here I have two don’t match. The first two indexes do match. I have a excel sheet to keep track of my shared parameters and I’ve updated it with a few new ones. I’ve added one before what used to be 37 (38 now) and two more between that and 89 (92 now). The file I’m using to organize mechanical parameter information is getting the update successfully. This is the formula I have for that.
=VLOOKUP(B4,’[Parameter Master.xlsm]Shared Parameters’!$C$5:$L$187,10,FALSE)
But even though the excel knows that Com_UnitService is 38 the dynamo node still thinks it’s 37. How is it returning 37 if it is reading a document that says 38?