@and.kj.cho (경진) posted a new topic, subject "How to put Excel information with conditions". It read:

   Hello  
    I am an office worker who is always studying while watching the forum.  
    I've been searching, but I'm stuck because I don't have the conditions I want. Please help me.
    
    If there are values of 1,2,3 in Excel, and the attributes of 1,2 match in Revit, I want to make 3 have attributes.
    
    Is there a way?
    
    ex) If the A and B values in the properties match in the figure below, I would like to put C values.  
    
    
    20210513_163035703×552 17.3 KB
    
      
    
    
    20210513_1631151161×740 33.8 KB
    
    카페 질의.xlsx (8.6 KB)  
    카페 질문 파일 ver2018.rvt (3.1 MB)

@AmolShah (Amol Shah) replied

    @and.kj.cho One of the easiest way would be to join the values in two columns and compare it against the joined values of the two parameters. Then you can use a dictionary to get the 3rd value and write it back to Revit.
    
    I'm joining two parameters with a hyphen “-” and the graph would look like this: Excel Lookup.dyn (37.3 KB)  
    
    
    Capture3594×1122 293 KB

@and.kj.cho (경진) replied

    Wow, it was hard for me to study, but I can understand well when I see the dynamo you made. Thank you. Thanks to you, I'm learning one more thing today. Thank you.

After which, @AmolShah (Amol Shah) added

    @and.kj.cho Glad I could help you out.  
    Good Luck with your Dynamo journey


{'source': 'discourse', 'url': 'https://forum.dynamobim.com/t/how-to-put-excel-information-with-conditions/64054', 'title': 'How to put Excel information with conditions', 'views': 225, 'has_accepted_answer': True, 'word_count': 243, 'like_count': 4, 'reply_count': 2, 'participant_count': 2, 'posts': 4, 'tags': 'dynamo excel', 'author': '@and.kj.cho (경진)', 'participants': '@and.kj.cho (경진), @AmolShah (Amol Shah)', 'image_url': ['https://global.discourse-cdn.com/business6/uploads/dynamobim/original/3X/a/c/ac3168433e8f11829a230b486fd13e5c95d5864f.png'], 'created_at': '2021-05-18T00:27:13.355Z', 'last_posted_at': '2021-05-18T03:22:29.229Z'}