Match and merge data from two lists

[Tobias_Barnes_Hofmei]

I am working on a project in which I am currently having three walls, which are composed of different materials. The upper watch node shows the various materials in each of the walls and their respective volumes. The lower list shows materials and specified corresponding parameters which I imported from Excel.

In a next step I wish to match these two lists in a way that the volume of each material will be multiplied with the appropriate material parameter, which I imported from Excel. Does anyone know how to do this?

[Kulkul]

Hi Tobias,
Similar topic is discussed here http://dynamobim.org/forums/topic/access-data-from-material-take-off-schedule-in-dynamo/

[Tobias_Barnes_Hofmei]

Hi Kulkul,

thank you for the quick response. Unfortunately it does not do the trick. Any other thoughts on how I could map one list over the other and match the corresponding parameters?

[Vikram_Subbaiah]

[Monkey_Puppet]

Tobias,
This sums the like materials before the multiplication. I am not sure if that is what you want.

[Tobias_Barnes_Hofmei]

Amazing, Vikram…exactly what I needed. Thank you.