Hello, I try to create a dynamo script that looks up an inch Pipe size value in an excel sheet based on the Pipe Segment name and his Metric size. In the picture below you see an example of two lists. Now I like to search with the Pipe information from the list on the bottom for the corresponding…

You could give a try with a Springs.Dictionary.ByKeysValues from spring nodes, see here: [image] Inconsistency by filtering Revit Hi @babysatch , I was working on it but @Yna_Db said it first! slight_smile I think it would be the best approach : [image]

Hi @Yna_Db , What I need is to search with two keys in a list and then return the value where I was looking for. Just what you could do with lookup tables in Revit. Filter all the rows that match (“A”) in the first column then filter all the rows that match (“15”) in the second column and read the…

Hello Robert, Good to see you on the forum :slight_smile: I think Yna is pointing in the right direction. Is this what you need?: [image] By concatenating the first 2 items in the list you can create unique keys to search the other list. Greetings, Taco

Another way with the concatenation approach suggested by @T_Pover [image] 20170112-1.dyn (10.3 KB)

Dear Vikram thanks a lot for all your good work towards the well of dynamo community. do you know how to get around this warning? [image]

Please create a new topic, this thread was finished 2 years ago and uses different version of Dynamo with different syntax. You can link to this thread in your new one. A new topic keeps things organized and lets you choose a solution so others with the same problem can get the correct answer. The …

Lookup value in a list and place it in other list

Revit

Yna_Db January 8, 2017, 8:34pm 2

You could give a try with a Springs.Dictionary.ByKeysValues from spring nodes, see here:

Topic		Replies	Views
Lookup Value equivalent in Dynamo? Revit	6	309	August 25, 2023
Searching the matching Index and transferring the index to another list DesignScript excel	8	3810	February 1, 2023
Reading from excel as strings vlook up Lists-Logic	45	4173	October 20, 2017
List matching based on key values Lists-Logic	2	5257	December 14, 2017
Index if values matches revit , excel , dynamo	8	5853	February 28, 2018

Lookup value in a list and place it in other list

Related topics