Forum Discussion

Sayarborough's avatar
Sayarborough
Copper Contributor
Aug 03, 2019

Grouping maybe? But how?

I have a database that has a column (B) called partners with seven companies listed sporadically throughout based off the row lines. I need to create a column (G) for Affiliations and create a functio...
excel
Formulas and Functions
Yury Tokarev's avatar
Yury Tokarev
Iron Contributor
Aug 03, 2019

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

Resources