# Parameter fron Excel to Revit with vlookup formula **URL:** \ **Category:** Revit\ **Created:** [June 19, 2017, 3:52pm UTC](https://forum.dynamobim.com/t/parameter-fron-excel-to-revit-with-vlookup-formula/12563 "2017-06-19T15:52:16Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Lpiu](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/lpiu/32/80998_2.png) [@Lpiu](https://forum.dynamobim.com/u/Lpiu)\ **Post date:** [June 19, 2017, 3:52pm UTC](https://forum.dynamobim.com/t/parameter-fron-excel-to-revit-with-vlookup-formula/12563/1 "2017-06-19T15:52:16Z")
Hello, I have a little experience with Dynamo. What I would is put in Dynamo a “vlookup” formula (like excel) that read a parameter in Revit and use excel to fill in another parameter a new data. Something like this **=VLOOKUP(A10;table\_array;n;FALSE)** Is it possible? ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [June 19, 2017, 7:16pm UTC](https://forum.dynamobim.com/t/parameter-fron-excel-to-revit-with-vlookup-formula/12563/2 "2017-06-19T19:16:43Z")
Yes. Several different ways. You need to show a little more dynamo or some other background to get specific help though. ---
**Author:** ![Lpiu](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/lpiu/32/80998_2.png) [@Lpiu](https://forum.dynamobim.com/u/Lpiu)\ **Post date:** [June 20, 2017, 7:28am UTC](https://forum.dynamobim.com/t/parameter-fron-excel-to-revit-with-vlookup-formula/12563/3 "2017-06-20T07:28:25Z")
Let’s talk about “Rooms” … in parsing parameter revit (eg “Name”), I would like another parameter (eg “Room Code”) to be compiled with a data derived from an excel table. I usually use a plug-in that exports an excel table and then reimports it (and obviously makes all my formulas) compile this parameter. The formula I use is “VLOOKUP”. Do you have any idea Thank you ---
**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\ **Post date:** [June 20, 2017, 7:43am UTC](https://forum.dynamobim.com/t/parameter-fron-excel-to-revit-with-vlookup-formula/12563/4 "2017-06-20T07:43:58Z")
You would need to use either: 1. Dynamo Dictionaries, or 2. Database lookups For 2. refer to [Using SQLite instead of Excel](https://forum.dynamobim.com/t/using-sqlite-instead-of-excel/4565) This example does what you want (using doors rather than rooms) [https://forum.dynamobim.com/uploads/short-url/wyxBAxzBdtdHKu1CMR9LzltEKKK.PNG](https://forum.dynamobim.com/uploads/short-url/wyxBAxzBdtdHKu1CMR9LzltEKKK.PNG) ---
**Author:** ![Lpiu](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/lpiu/32/80998_2.png) [@Lpiu](https://forum.dynamobim.com/u/Lpiu)\ **Post date:** [June 20, 2017, 8:48am UTC](https://forum.dynamobim.com/t/parameter-fron-excel-to-revit-with-vlookup-formula/12563/5 "2017-06-20T08:48:48Z")
How may I do with Dynamo Dictionaries? ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [June 20, 2017, 1:39pm UTC](https://forum.dynamobim.com/t/parameter-fron-excel-to-revit-with-vlookup-formula/12563/6 "2017-06-20T13:39:55Z")
Try this as a start. [https://forum.dynamobim.com/t/logic-if-value-matches-a-value-in-a-dictionary-append-associated-value](https://forum.dynamobim.com/t/logic-if-value-matches-a-value-in-a-dictionary-append-associated-value) > [@LOGIC If value matches a value in a dictionary , append associated value](https://forum.dynamobim.com/t/logic-if-value-matches-a-value-in-a-dictionary-append-associated-value/3046/8): > > The “Dictionary.ByKeysValues” node from spring nodes makes an actual dictionary and should perform much faster for large data sets. (because evaluations are not free) If you get stuck post your graph and we can help troubleshoot. ---
**Author:** ![amyll](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/amyll/32/21900_2.png) [@amyll](https://forum.dynamobim.com/u/amyll)\ **Post date:** [July 12, 2017, 6:23am UTC](https://forum.dynamobim.com/t/parameter-fron-excel-to-revit-with-vlookup-formula/12563/7 "2017-07-12T06:23:58Z")
I’m looking for something like this post as well. In stead of reading a parameter in revit, I want to set a parameter with data from from a spreadsheet with a Vlookup formula. I want to compare roomnames from the model with a column from the spread sheet and when there’s a match, it should set the parameter with a value from another column (index). Is that possible? I have read a lot of post similar to this, but i just dont know how to do the VLookUp formula in dynamo… ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/8/d821056214a9efeeb5e031f46957af2862689daa.png) ---
**Author:** ![4bimfercesp](https://avatars.discourse-cdn.com/v4/letter/4/b782af/32.png) [@4bimfercesp](https://forum.dynamobim.com/u/4bimfercesp)\ **Post date:** [July 12, 2017, 7:55am UTC](https://forum.dynamobim.com/t/parameter-fron-excel-to-revit-with-vlookup-formula/12563/8 "2017-07-12T07:55:14Z")
Hi…yes completely possible. Your meaning of vlookup formula could throw up people who may know how to compare list and replace values to answer your query. Your problem was already solved and discussed numerous times. If you look for topics like compare list and replaced and review to suit your needs. Do not mix vlookup to dynamo coz when it comes to dynamo its just a list of list…all about list. Tnx