OK, assuming 'Consumer Groups'!A$3:A$89 have no duplicate values. across column may have multiple 'X' entered.
Try this Array Formula in B2, with CTRL+SHIFT+ENTER
=IFERROR(INDEX('Consumer Groups'!B$2:CG$2,SMALL(IF(INDEX('Consumer Groups'!B$3:CG$89,MATCH('Consumer Support Staff'!J$3,'Consumer Groups'!A$3:A$89,0),0)="X",COLUMN('Consumer Groups'!$B$2:$CG$2)),ROWS(B$2:B2))-COLUMN('Consumer Groups'!B$2)+1),"")
Then copy B2, paste down as needed.
If this not works, please attach a sample file to reflect your data layout.
Bookmarks