如何在两个表中匹配名称?

I am using excel to keep track of attendance but i find this very difficult. Is there a way/formula for this?I am using excel to keep track of attendance bu