Hi Pat,
Sample file attached - I would like the formulas to read from the parameters in Column B (ie Floor level, building, position) which relate to fields from my space objects. It works for fields that have text inputs (A,B,C etc) but not for numerical input. I guess a work around would be to use 'One' instead of '1' for floor level etc but this seems a bit clumsy.
I have pasted my spaces into a clean worksheet so I am pretty sure there aren't duplicates and there are no viewports.
Thanks,
Tim