List from a Table

in Column 6, enter =IF(UPPER(TRIM(B4))="PST",$A4,""). Just change the reference to B1 if your list starting from A1

=IFERROR(INDEX($A$2:$A$5,SMALL(IF($E$2:$E$5="pst",ROW($A$2:$SA$5)-ROW($A$2)+1),ROWS($A$1:$A1))),"")

confirmed wit CTRL+SHIFT+ENTER not just ENTER and copied down.

=IFERROR(INDEX($A$2:$A$5,SMALL(IF($D$2:$D$5="pst",IF($E$2:$E$5="pst",ROW($A$2:$SA$5)-ROW($A$2)+1)),ROWS($A$1:$A1))),"")

Yes as long as the named ranges are all same size...

=IFERROR(INDEX(SMCatMerchs,SMALL(IF(CycleA="pst",ROW(SMCatMerchs)-MIN(ROW(SMCatMerchs))+1),ROWS($C$1:$C1))),"")

CSE confirmed.

Your named range for the managers is Managers... not SMCatMerchs

Try:

=IFERROR(INDEX(Managers,SMALL(IF(CycleA="pst",ROW(Managers)-MIN(ROW(Managers))+1),ROWS($C$1:$C1))),"")

Also, your CycleA is 3 columns wide, so this will return the names in pst is any of those 3 columns... (assumes once max per row)

After entering the formula, are you holding the CTRL and SHIFT keys down, then pressing ENTER? You should see curly { } brackets appear around the formula.

You've got several formulas in one cell.

Expand the formula bar up top and you will see... remove all except the correct one, then do the CSE confirmation... I posted a workbook in my last post.