You can try this:

Add titles to Y1:AA1 (which are the same as results you want returned for the respective columns).. then use formula:

=IFERROR(INDEX($Y$1:$AA$1,SUMPRODUCT(($Y$2:$AA$5=$ A2)*((COLUMN($Y$2:$AA$5)-COLUMN($Y$2:$Y$5)+1)))),"")

copied down.

or if you only have 2 or three possibilies a simple nested if..

=IF(ISNUMBER(MATCH(A2,$Y$2:$Y$10,0)),"NSA",IF( ISNUMBER(MATCH(A2,$Z$2:$Z$10,0)),"MEEPA",IF( ISNUMBER(MATCH(A2,$AA$2:$AA$10,0)),"EUM","")))