I have two lists that I want to compare. I have numbers in both lists, one in column C, the second in column H. I then have information in column I. I want to compare the list in column H to that in C. If a match is found between the two columns, I want excel to put the information in column I into column D. To complicate matters, there may be duplicate numbers within column H, but the data in the row's respective column I is different, but I want all of the information in both identical rows of column I to be in the single cell for the match of column C to go into column D. I have supplied an example because I know that sounds confusing. If it helps, the comma in Column D isn't needed just so the words are different (FYI, the words in column I and D are actually numbers as well, I just went with words so it isn't so confusing looking). Thanks, Ryan.
<tbody>
</tbody>
column C | Column D | E | F | G | Column H | Column I |
100 | Apple | 100 | Apple | |||
200 | Orange, Banana | 200 | Orange | |||
250 | 200 | Banana | ||||
400 | Apple | 300 | Apple | |||
500 | Apple, Lemon | 400 | Apple | |||
600 | 500 | Apple | ||||
700 | Apricot | 500 | Lemon | |||
700 | Apricot | |||||
800 | Watermelon |
<tbody>
</tbody>