Partial success. I've managed to find a solution for the first part by using XLOOKUP in the following format
=XLOOKUP(1,(TblPhase[Phase]=C2)*(TblPhase[Mcount]=C4),TblPhase[Action])
Still need help in working out how to display only those chemicals that are available whether you have supers on or not.