Can someone tell me why the formula in Column A of the Master List worksheet does not work? See attached file.
I expect the text in Column A to change based upon whether there was a match in Email Address between the two worksheets.
I expected to see the following result:
Action Full Name
Completed Training McCarthy, Nathan
DID NOT TAKE TRAINING Richardson, Christian
Completed Training Ross, Rachel
DID NOT TAKE TRAINING Abdullah, Mohamed
Completed Training Adrian, Matthew C
DID NOT TAKE TRAINING Alexander, Kori M