Hello, sorry if this question has been asked before...(I'm sure it has, I've found numerous responses through google but haven't had any luck for my example)

I have data set that looks like this:


Col A Col B Col C
0/0/0/0/ 0/0/1/0/ 1/28
0/0/0/1/ 0/0/1/0/ 1/29
0/0/1/0/ 0/0/1/1/ 1/41
0/0/1/1/ 0/0/1/1/ 0/16


Basically, I want to check if the text in Col B matches any text in Col A, then return the nth match in Col C. Ideally, my result would look like this:


Col A Col B Col C Col D(first match) Col E(second match)
0/0/0/0/ 0/0/1/0/ 1/28
0/0/0/1/ 0/0/1/0/ 1/29
0/0/1/0/ 0/0/1/1/ 1/41 1/28 1/29
0/0/1/1/ 0/0/1/1/ 0/16 1/41 0/16

Here, 0/0/0/0/ isn't in ColB, so Col D and E are blank. 0/0/1/0 matches twice in Col B, so Col D and E here are 1/28 and 1/29 respectively


Any help here would be GREATLY appreciated