Which Group does a name belong to?

Consider this problem The table above gives the groups in which each of the members belong. the problem here is to find out in which group one of the member belongs to e.g. Keith (A12). The formula used in B12 is =INDEX($A$1:$C$1,1,SUMPRODUCT(- -ISNUMBER(SEARCH(A12,$A$2:$C$8)),{1,2,3}*{1;1;1;1;1;1;1})) The way this works is Search function searches for Keith (A12) in [...]

Read Full Post »