It would help if you gave some details about how your data is laid
out, what sheets, columns, rows etc that you use, perhaps with some
examples of what you have and what you want to achieve.

Pete

On Jul 21, 7:16*pm, Maureen wrote:
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