If "X" in Column Return List in Tables

[fredfarmer]

Hi,

On my Employees sheet I have columns G:I with X's in them. Are there formulas to fill the Clerks, Technicians, and Repairmen tables with the names from column E if there is a matching "X" ?

Thank you for any help or suggestion,
FF

[fredfarmer]

I figured it out in cell K4

=IFERROR(INDEX($E$4:$E$15,SMALL(IF($G$2=G$4:G$15,ROW($E$4:$E$15)-ROW($E$4)+1),ROW(1:1))),"")

Press CTRL+SHIFT+ENTER to make it an array.