Skip to Content
Author's profile photo Former Member

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.

Attachment Size
Excel_Logic.xlf 754.05 KB
Lookup a Range.xls 77 KB

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.