Compiling a staff rota of names from a table array containing names assigned as letters

[tanners1456]

Hi there, I am struggling to work out what formula would be suitable for the output table such that it reads the letters in each cell of the input table, retrieves the relevant name from the assigned letter from the reference table and then prints
the names into the output cell (this could be one or multiple names depending on who is working.) see an attached example....

Thanks in advance for your help!
Screenshot 2019-08-13 at 09.22.53.png

[avk]

Instead of picture, attach workbook.

[KOKOSEK]

Hi

	B	C	D	E	F	G	H
2	AB	B	C	D		ID Letter	Names
3	BA	BC	CD	E		A	Alyshia
4						B	James
5	output					C	Barry
6	Alyshia,James	James	Barry	Trisha		D	Trisha
7	James,Alyshia	James,Barry	Barry,Trisha	Paul		E	Paul

	B
6	=TEXTJOIN(",",1,LOOKUP(MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1),$G$3:$G$7,$H$3:$H$7))

Sheet: Sheet1

This is array formula so needs to be accept with Ctrl+Shift+Enter, not just Enter.
Then drag it left (to E6) and down.

[tanners1456]

That seems to work, but does not print multiple names in the same cell.

For example the first cell AB, should read "Alyshia, James."

Any ideas how to get it to work for multiple names?

[KOKOSEK]

as you see in my post in B6, I've got Alyshia, James so works with multiple (also B7, C7 or D7).
Did you accept formula with Ctrl+Shift+Delete?
Does Mac Excel works with TEXTJOIN function?