Looking for a help with excel Formula

My master data (SHEET 1) consists of a set of names in one of the columns and another column has the date when a particular ticket was assigned to. In another (SHEET 2), I have those names in the fir...