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 Pipe and diameter in the list on the top and read the third item on the list so the question mark will be filled in with the right value in the Pipe list.
Then I like to update that value back to the Pipes in Revit.
Any suggestion how to do this.