Harlan Grove wrote...
jac007 wrote...
I get an error of "few arguments". . . .

Sorry, it should be

Sheet1!B2:
=REPT("X",COUNTIF(INDEX(GUTable,MATCH(B$1,INDEX(G UTable,0,1),0),0),$A2))

Omitted the 2nd ,0) .
....

However, now I see that GUTable could have multiple rows for the same
group. In that case, use the following array formula in Sheet1 cell B2.

=REPT("X",Min(1,SUM(--(IF(INDEX(GUTable,0,1)=B$1,
INDEX(GUTable,1,2):INDEX(GUTable,ROWS(GUTable),5)) =$A2))))

Fill B2 right into C2:Z2, then select B2:Z2 and fill down into B3:Z256.