- "that process name" should refer to something. It doesn't. According to most definitions a task is not the same as a process.
- "their" in "their employee id" seems to refer to nothing. Not to "a cell" anyway, because cells don't have employee id's.
- and it's not clear what the attributes (columns) of a certain training (a row in the list of trainings) are.
- somehow the list of participants of a training seems to be missing in your spec.
In stead of a programmer you seem to be in need of an analist first.
By the way, why not try a real database (like MS Access) for this purpose?
Alright, so this one goes out to the advance excel "programmers" out there.
I have a workbook that has multiple sheets within it. One sheet lists various tasks that a person has been working on over a period of time. Another has a list of trainings that have taken place over a period of time.
What I'm wanting to do is populate a cell with a "yes" or "no" value if their employee id is present on the training spreadsheet along with that process name.