Dynamic Excel Lookup Logic for Xcelsius
by Ryan Goodman
Here is a scenario that many people have &. You have a connected model and the web service returns an array, but Xcelsius does not have the ability to lookup multiple rows of data with their selectors. Unfortunately, with Xcelsius 4.5 you have to rely on some Excel skills to assemble a layer of logic that will scale. The good news is I have put together a lightweight solution with the available supported Excel functions for Xcelsius. The bad news is that is painful to explain & I did my best to point out the key components to make this model work. Your best bet is to download the Excel file and beat it up and look at the comments within the bold titles.
|Lookup a Range.xls||77 KB|