Hi!
I am trying to determine how many of our students are later hired by our institution. I have a Sheet with a Student Name column , and would like to add a "Hired" Column in this sheet that would cross reference to a second sheet (Master employee list) and flag if there is a match in the Employee Name column (so if a student was hired and popped up on the Master employee list, the Value in the Hired Column would say Yes or a checkmark, etc). I have read tutorials about Index Match and Lookup, but every time I try to write a formula for this I just keep getting errors. Can someone help me? I feel like this shouldn't be hard and I am overcomplicating it. Thank you!
