Match Excel Room Number to Parameter Room Number

I have an uneven list of room numbers from a Revit file and an excel file. I need to set parameters from the excel list to the rooms in revit. (Need to add name of person in room and there phone extension) How can i reorder my list so i can set the parameters to the rooms in revit.
Thanks for any help ahead of time!

Attempt 1:


Attempt 2:

Any mismatches (for instance, if the excel file is missing room numbers) turn up as null. Any matches are re-ordered to match the Revit element list.

Now that the list ordering is organized, you can extract the sublist data and feed as appropriate into your parameter setting sections.

1 Like

Robert, So it only found 2 matches. What am i doing wrong?

Not positive as the watchlists are for the most part out of range of one another (I spotted one match?)
Can you confirm how many matches are supposed to be there? Use a list.sort on both to visually check.

It may have something to do with the storage type. Try converting both lists to string objects before making the comparison.

1 Like

That worked!! Thank you!!

Final Image: