title: Matching based on conditional data
body: <p>I have two Dfs with multiple rows and columns. I want to see if Df1$Name matches Df2$Name.  If it matches, I want it to take match value and create a new variable in DF3. But if it doesn't match, I want to paste the value from Df1.  The issue is that Df1 has 270 observations and Df2 has 277.</p>
  
  <p>See example:</p>
  
  <pre><code>Df1
         Name      
         Natalie   
         Desmond,James   
         Kylie     
  
  Df2
          Name      
           &lt;Na&gt;
          Desmond,James  
          &lt;Na&gt;
   Df3    
          Merged_name
          Natalie
          Desomond,James
          Kylie
  </code></pre>
  
  <p>I've tried:</p>
  
  <pre><code>Df3$Merged_name &lt;- ifelse(Df1Name %in% Df$Name 
                &amp; !is.na(Df2$Name), Df1$Name 
                   , Df2$Name)
  </code></pre>
  
  <p>I get an error saying that the longer object length is not a multiple of shorter object 
  length which I'm assuming is due to the varying observations. Do I have to separate rows that have more than one name in it(i.e. separate_rows())? If so, how do I re-merge back together?</p>