Create a lookup list

A1: Startup
A2: Enrollment Open
A3: Enrollment Close
A4: Treatment
A5: On Hold
A6: Terminated


REPT("Yes",COUNTIF(A1:A6,E2))



"PAL" wrote:

Can someone help with this formula, or perhaps come up with a simpler version?

=IF(E2="Startup","Yes",IF(E2="Enrollment Open","Yes",IF(E2="Enrollment
Closed","Yes",IF(E2="Treatment","Yes",IF(E2="Start up","Yes",IF(E2="On
Hold","Yes",IF(E2="Terminated,"Yes","")))))