title: Matching values from multiple columns to populate another
body: <p>I am trying to compare column A against column B. When there is a match, I'd Like to populate a resulting column (column D) with data from column C.</p>
  
  <p>I have a partial parts list (column A) that I am comparing against a complete parts list (column B). When a match occurs, I'd like to extract the corresponding data from complete parts list, nomenclature (column C) and place it next to the matching part number in column A.</p>
  
  <p>BEFORE</p>
  
  <pre><code>Column A         Column B                  Column C           Column D
  Part Number      Description               Part Number        Description
  123456           Bolt                      123456
  </code></pre>
  
  <p>AFTER</p>
  
  <pre><code>Column A         Column B                  Column C           Column D
  Part Number      Description               Part Number        Description
  123456           Bolt                      123456             Bolt
  </code></pre>