How to combine two lists by matching them according to the common item

Hello,

I have two lists, one from excel (containing material name, material ID, density and GWP value) and one from revit (containing Revit material name, material ID and material volume) and I would like to combine them by sorting them according to the same Material ID assigned. I had created a parameter called MaterialID in Revit to assign the same material ID to match the materials in excel to the same ones in revit.

I would greatly appreciately some help as I am still new to this! I have attached some photos.

Hi brother
Try this out this will work


have a good day