Hello
I would like to ask for the formula on this one. Here's the scenario
Sheet 1 - Vlook up the column B(Name) - Vlook-up the completion date from "Data" tab, then if date exist the status on the "Final Status Column" should be "Completed" otherwise "Not Completed".
I have attached the file for your reference.
Thank You in Advance
Bookmarks