Hi there, my first post here
Here is my problem I am looking for help with.

How can I match the number in row B, based on only looking up values with same group Nr, guess that will be combining A&B, and get the first match in D, and second in E from row C,
AD values excluded. What I want to see is put in D

A B C D
Group Nr
1 111: 954112 0000 or 955112 0000 + 044112 0500 + xxx
1 222: 954112 0000 or 955112 0000 + 954312 0000 xxx + 044112 0500 + xxx
1 333 L/R: 954112 0000 or 955112 0000 + 045112 1500 + xxx
1 444: 954112 0000 or 955112 0000 + 954312 0000 xxx
1 954312 0000 xxx 222 (Lineshift) &"or " 444
1 954112 0000 xxx 111 (Lineshift) &"or " 222 (Lineshift) &"or " 333 (Lineshift) &"or " 444
1 955112 0000 xxx 111 (Lineshift) &"or " 222 (Lineshift) &"or " 333 (Lineshift) &"or " 444
1 yyy
2 0007 04G xxx

Hope and thx in advance