Hi. The function I am looking for is a Lookup function, but I do not get it right. I have given two simplified tables below to explain. I need a function for the Date completed in table 1. Who can help me? Thanks in advance. Regards, Tom.
Look up in table 2 the same name and training as in table 1. Check if the status is "Completed". If yes, return the 'Date Completed' in this cell. If no, return the value "0" in this cell.