Hi pecoflyer, I should be clearer in the issue i had encountered.
i did what you said, but doesn't seems to be able to do that.
when the grouping are "A,B,C,D" when i put any of them to lookup in C11, it works,
but when i change it to "Team 1, Team 2, Team 3, team 4" and i put the indentical input to C11. it doesn't work...
|