Searching for string in excel and writing corresponding values

Hi guys!
I have a demo excel file (not complete, only for testing), from which I want to search for the string. And if it is present in it, I will get the number written next to it.
Also the element names in Revit and Excel file are not 100% same, so it would be better if someone suggests how to use contain string in this case.


Hello @salmanjavaid2000 ,


New Microsoft Excel Worksheet.xlsx (10.5 KB)
Data Excel.dyn (23.5 KB)

Hope this script will help you,

Yup this worked. Just had to change the custom node a bit, because it was built in an older version.
Thanks a lot :slight_smile: