I am struggling figuring out how to match two lists. One imported from Excel and the other one is from the model. I actually have created Excel sheet including spaces names and airflow. I want to assign that airflow from the excel sheet to their corresponding spaces in the model by space names and numbers knowing that in the model there are some irrelevant spaces and the excel sheet have only the spaces that are relevant. So, in the excel sheet there are more spaces that that in the model.
Can anybody help in this?
the easiest method is probably to use a dictionary
This and other methods are covered fairly well in this forum- so if you search for ‘dictionary’ or ‘lookup’ you will find some useful posts