Thanks for replying, NBVC. I tried that, it returned the first instance of the employee, name, the Title of the training course. How about if we go about this a different way. maybe with a IF/AND statement. What if Excel searches ATMS column M, finds the Date/Time (formatted as:mm/dd/yyyy hr:mm:ss) AND matches the employee name in ATMS column B, AND employee name in Quals column M, returns the text in ATMS column I? Do you think that is a working scenario? I tried this one:
=IF(AND(ATMS!M389="MM/DD/YYYY","HH:MM:SS"),ATMS!I389)
and it returned a #VALUE! error. What did I do wrong?