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.
For example
___ A_________B_________C__________D___________E
New York______1_________ 2 _______ Dallas _____ _ New York,
Chicago ______3 _________ 3 _______ Seattle _____ Chicago, Seattle, Houston,
LA __________ 4 _________ 3 _______ Houston _____ LA, Denver,
Boston _______ 5 _________ 4 ______ Denver _______ Boston,
Column A & B's value are linked, and columns C & D's values are linked. I'm trying to find a way to find matching values in columns B & C, and then create a single column of the corresponding A & D values listed together, delimited by semicolons.