# Populate parameter from excel by key value

**URL:** <https://forum.dynamobim.com/t/populate-parameter-from-excel-by-key-value/81320>\
**Category:** Revit\
**Tags:** excel\
**Created:** [September 21, 2022, 6:08pm UTC](https://forum.dynamobim.com/t/populate-parameter-from-excel-by-key-value/81320 "2022-09-21T18:08:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![laura.d.morgan](https://avatars.discourse-cdn.com/v4/letter/l/8797f3/32.png) [@laura.d.morgan](https://forum.dynamobim.com/u/laura.d.morgan)\
**Post date:** [September 21, 2022, 6:08pm UTC](https://forum.dynamobim.com/t/populate-parameter-from-excel-by-key-value/81320/1 "2022-09-21T18:08:44Z")

</div>

I am a brand new Dynamo utilizer. I am trying to figure out how to create a dynamo script to pull room data from an Excel spreadsheet to populate “occupancy” and “department” Identity data in Revit.  
I was excited to find what i thought I needed in a tutorial by Archsmarter. (my interpretation attached) and it almost does what I want. But I need the results to be based on the room number, independent of the indices. So a bit more reading and it seems that I need to utilize Dictionaries. but I cant figure out how to incorporate dictionary-type input into my graph.

can anyone recommend a place to start or a good video or two?

 ![excel space management](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/c/0c809afe55131e744fec3a658af196bc5a7fe12d.jpeg)

---

<div class="post-metadata">

**Author:** ![Marcel\_Rijsmus](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/marcel_rijsmus/32/8539_2.png) [@Marcel\_Rijsmus](https://forum.dynamobim.com/u/Marcel_Rijsmus)\
**Post date:** [September 21, 2022, 6:23pm UTC](https://forum.dynamobim.com/t/populate-parameter-from-excel-by-key-value/81320/2 "2022-09-21T18:23:00Z")

</div>

It’s simple,  
You need

1. an identifier (something else that matches) (most ideal is the Id or the UniqueId)
2. a value that goes with it, like the lookup function in Excel.

You can have more than one Dictionary. but keep in mind the identifier.  
Then insert a parameter value to lookup, and the corresponding Element will present itself to you to play with.  
The Dictionary.ValueAtKey node will do the trick  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/b/fb000af94d040381117741bad00b18dd73729e73.jpeg)
