I want to lookup a value from a table in a second table. I only want to return a value if there's a value in that second table. For example, i want to look up the account in table 1, find the account in table 2, and return the department value, but ignoring any department values that are blank; only returning the department value of (in this example) 600.  As I have my formula currently, apptio is returning various because it recognizes that the blanks are "values." I can't group down table 2 because I need the granularity of that table for other purposes. 

Hey @Kyle Sellner, in that case, I would create a copy of the table and group the copy down and use that solely for the lookup.  You can create a copy of the table by right-clicking on the Table step and selecting 'Create New Table from This Step'.

thanks for the idea!

I have tried something like that in the past: having a special transform for a specific purpose is very useful. As a bonus tip, try hiding all the columns you don't need, leaving just the one you need for the lookup (Account), and the one with the return value (Cost Center).

@Jenny Franklin, always on the ball! 😎😎😎