You would need to use either:
- Dynamo Dictionaries, or
- Database lookups
For 2. refer to Using SQLite instead of Excel
This example does what you want (using doors rather than rooms)
https://forum.dynamobim.com/uploads/short-url/wyxBAxzBdtdHKu1CMR9LzltEKKK.PNG
