Compare Excel Values and Revit Parameter - Write From Excel To Revit

Dear All,

Apologies if this topic exists but searched and could not find what I was looking for.

Within my Revit model I have an instance based parameter which has been populated for all elements. I then have an Excel referencing document. The Revit models instance parameter has been populated manually by a previous user from Column A of the Excel document.

I need to create a script to read the Excel referencing document and where it recognises matching values between Revit and Excel - Column A, to populate another instance parameter for the same element with the contents of Column E.

As you can see from the screenshot, I am a Dynamo beginner. I can read the Excel but what function do I need to align the parameter values with list 0 and populate the Set.Parameter with matching list 5 values?

Many Thanks,


Managed to get it to work like the attached image.


May I ask if you still have this solution. The image has bad resolution, It is not possible to see nodes.