OK I think I understand.
Formula:
=IFERROR(INDEX(IF(ISNUMBER(FIND("MS",$D$4:$D$14)),$D$4:$D$14,""),MATCH(G4,$C$4:$C$14,
--EXACT((INDEX(IF(ISNUMBER(FIND("MS",$D$4:$D$14)),$D$4:$D$14,""),MATCH(G4,$C$4:$C$14,0))),
(INDEX(IF(ISNUMBER(FIND("MS",$D$4:$D$14)),$D$4:$D$14,""),MATCH(G4,$C$4:$C$14,1)))))),"")
|
C |
D |
E |
F |
G |
H |
I |
1 |
General Table |
|
|
|
Dashboard |
|
|
2 |
|
|
|
|
|
|
|
3 |
Solution-ID |
Milestone |
|
|
Solution-ID |
|
|
4 |
1 |
MS4 |
|
|
1 |
MS4 |
|
5 |
2 |
MS2 |
|
|
2 |
MS2 |
|
6 |
2 |
MS9 |
|
|
3 |
MS9 |
<- should be MS9 |
7 |
3 |
MS9 |
|
|
4 |
MS4 |
|
8 |
3 |
MS9 |
|
|
5 |
|
|
9 |
3 |
No Onboarding |
|
|
6 |
MS9 |
<- should be MS9 |
10 |
3 |
No Onboarding |
|
|
7 |
|
|
11 |
4 |
MS4 |
|
|
|
|
|
12 |
5 |
No Onboarding |
|
|
|
|
|
13 |
6 |
MS9 |
|
|
|
|
|
14 |
6 |
MS9 |
|
|
|
|
|
Bookmarks