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

**URL:** <https://forum.dynamobim.com/t/compare-excel-values-and-revit-parameter-write-from-excel-to-revit/39051>\
**Category:** Uncategorized\
**Created:** [August 2, 2019, 12:03pm UTC](https://forum.dynamobim.com/t/compare-excel-values-and-revit-parameter-write-from-excel-to-revit/39051 "2019-08-02T12:03:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lee540](https://avatars.discourse-cdn.com/v4/letter/l/c77e96/32.png) [@lee540](https://forum.dynamobim.com/u/lee540)\
**Post date:** [August 2, 2019, 12:03pm UTC](https://forum.dynamobim.com/t/compare-excel-values-and-revit-parameter-write-from-excel-to-revit/39051/1 "2019-08-02T12:03:37Z")

</div>

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,

Lee

 ![excel_to_revit_lookup](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/b/1bc6f2fbf14bc965a17cb35265a449fb2359ea2e.png)

---

<div class="post-metadata">

**Author:** ![lee540](https://avatars.discourse-cdn.com/v4/letter/l/c77e96/32.png) [@lee540](https://forum.dynamobim.com/u/lee540)\
**Post date:** [August 2, 2019, 1:23pm UTC](https://forum.dynamobim.com/t/compare-excel-values-and-revit-parameter-write-from-excel-to-revit/39051/2 "2019-08-02T13:23:09Z")

</div>

Managed to get it to work like the attached image.

 ![excel_to_revit_lookup_2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/1/e1ff4b172e0e9097f69a7e5c93a1d4e80548ece3.png)

---

<div class="post-metadata">

**Author:** ![rasa.zukauskaite](https://avatars.discourse-cdn.com/v4/letter/r/85f322/32.png) [@rasa.zukauskaite](https://forum.dynamobim.com/u/rasa.zukauskaite)\
**Post date:** [January 14, 2020, 8:15am UTC](https://forum.dynamobim.com/t/compare-excel-values-and-revit-parameter-write-from-excel-to-revit/39051/3 "2020-01-14T08:15:27Z")

</div>

Hello,

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