Date Match Formula Needed

[ahvampire]

kindly help me guyz to get this formula
i need to fill table 1 automatically from table 2
i need each name get the specific type once he reach the same date like for example once we reach Jan/2018 it will write down next to the name that A B C on the specific column on the specific date
check pictures :
https://ibb.co/eXgZ7G
https://ibb.co/cbXJZw

Excel File Workbook :
https://ufile.io/lz4e0

CrossPost : https://www.mrexcel.com/forum/excel-...la-needed.html