I have created a spreadsheet to track staff's ongoing professional
development for the year. There are 6 specific topics that HAVE to be
repeated every year, then the employee can attend any other work related
workshop they want. I want to create a formula/function that will tell me if
all 6 topics have been completed. I think I need an "IF" or "LOOKUP"
statement that looks at a specific list (containing the required workshops).
Can anyone help me construct that formula?

Thanks in advance. . . Maureen