Check if array contains specific text(multiple matches possible), return row number

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

Please delete this post.