Aug 02 2019 05:24 PM
Aug 02 2019 06:39 PM
Hi @Sayarborough ,
I suggest creating a mapping table with two columns, first column listing Partners, and the second - Group Name they belong to. Assuming that the mapping table is in the range K1:L9 with first row being headers, your formula in G2 would be =INDEX($L$2:$L$9,MATCH(B2,$K$2:$K$9,0))
Thanks
Yury
Aug 02 2019 08:53 PM
If you want to avoid a mapping table, although I discourage you to do so, your formula in G2, copied down rows, would be:
="Group "&
IF(OR(B2={"Aone","Atwo","Athree","Afour"}),
"A","B")
Note that the names in the logical1 argument of OR are assumed.