Quote Originally Posted by NBVC View Post
Actually one more correction/change...

in E2, we can actually just use this formula:

=INDEX(B$2:B$4,MATCH(D2,SEARCH(A$2:A$4,C2),0))
CSE confirmed


since in C2, we already pulled the cell string...
I've entered some values and i think it's just about there


Last couple of issues:

1/ When there is a match for male but not for female (or vice versa) it shows #N/A in S on AWorkbookin... can it show either Male or Female in S?

2/ When there isn't a match for male or female it shows #N/A in S on AWorkbookin... can it leave S blank?