Parameter fron Excel to Revit with vlookup formula

[jacob.small]

Try this as a start.

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

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) [DynamoSandbox_2016-01-30_10-34-29]

If you get stuck post your graph and we can help troubleshoot.