title: Identifying duplicate cell values in two columns, and listing separate corresponding column data together
body: <p>I'm working with VBA for excel and I am trying to compare two columns of data, identify what row the matching data is in, and then listing the data from a corresponding column from the same row with corresponding data from a column that matches the row of the value being tested.</p>
  
  <p>For example </p>
  
  <p>___ A_________B_________C__________D___________E</p>
  
  <p>New York______1_________          2 _______       Dallas _____     _ New York,</p>
  
  <p>Chicago        ______3 _________         3  _______      Seattle   _____   Chicago, Seattle, Houston,</p>
  
  <p>LA        __________     4  _________        3 _______       Houston _____     LA, Denver,</p>
  
  <p>Boston   _______      5  _________        4    ______    Denver     _______  Boston,</p>
  
  <p>Column A &amp; B's value are linked, and columns C &amp; D's values are linked. I'm trying to find a way to find matching values in columns B &amp; C, and then create a single column of the corresponding A &amp; D values listed together, delimited by semicolons.</p>