nesting IF and AND statements

[mcintoshmc]

Row 1 contains several columns. The ones I'm concerned about are:
F2 and L2. F2 will give you a status of "yes" or "no" if they enrolled or not. L2 will give you their program of interest. It will either say....
PT1, PT3, MB1, MB3, MT1, MT3, MA1, MA3, DA1, DA3, CST1, CST3, BOA1, BOA3.

On the farthest column (N) i want it to say PT, or DA, or whatever program it is, without the number. I can get it to work for just 1 program by using =IF(AND(L2='Starts Chart'!$F$25,F2="yes"),"PT","")
F25 says PT1, F26 will say PT3, and G25 will say MB1. I think you get the picture. What formula can I use to include all programs 1 and 3?

 

[mcintoshmc]

what do you know about creating lists? is there a formula that I could use with out having to delete cells?

 

[Scott Huish]

Not a list expert, but why do you have to delete cells in order to create a list? What are you trying to do exactly?

 

[mcintoshmc]

Not a list expert, but why do you have to delete cells in order to create a list? What are you trying to do exactly?

Work Sheet 1 has a cell that will read either "yes" or "no" the name of the column is Enrolled. If the person enrolls, then I want a list to be created on a seperate worksheet of that persons name, startdate, and graddate. I have been manually creating entries for that sheet(its the one you just helped me with)

I want to know is it possible to have excel automatically add to the current list once an enrolled status is changed to "yes" on sheet 1?

 

[mcintoshmc]

and you have to delete cells because if cell 1 on worksheet enrolls, then that student will want to go to cell 1 on the other worksheet. If cell 10 enrolls, then he will want to be on cell 10 in the other sheet. then you would have to delete cells 2 through 9. I want it as if I enrolled 60 people out of 200, that there will be a list of 60 people on the other worksheet.

 

[mcintoshmc]

even if only name copied over, I would be happy