Basic list filterering and setting of parameters based on value

Revit
,
1

Hi I have a basic task which my list logic fails to meet.
I have an excel with room names and I want to lookup that excel.
For every room in the project I want to Set some room parameters based on the values defined by the room name in the excel.

I’m sure this is very simple but my list competence really lets me down here. What’s the best approach. Please see what I have so far. all the the room names. a list of the room names to reference and their parameters.
Much apreciated
22061 - Room Finishes.dyn (24.6 KB)

image
image1747×1168 339 KB

2

Dictionaries.

image
image944×446 66.7 KB

You can create the dictionaries from your Excel.

image
image1247×616 97.2 KB

1 Like
3

There are a ton of other threads dealing with this exact issue that can give you more context if you need it.

4

Yes of course dictionaries, I think I’ve got what I need. I’ll update with what I have in a bit and you’ll have a better way to do it. Thanks @bvs1982