Add check mark in cell if value in another worksheet

[jgangone]

I have a worksheet that has a formula to check for attendance. So I copy attendance from one note and paste into cell A. I then have a formula that says =IF(ISERROR(VLOOKUP(P2,$F$2:$F$41,1,FALSE)),"",(VLOOKUP(P2,$F$2:$F$41,1,FALSE)))

If that person was in the attendance there name will show

On another sheet I have a team name with a check mark next to it. If the person from this team was in attendance then I want to add a check mark to the cell.

Can a formula do this?

 

[sijpie]

Yes and no.

You can set a formula which will return TRUE for the checkmark to be automatically checked. But as soon as you change the value in cell A, then the checkmark will disappear again. I don't think that is what you want.
A macro could achieve this for you to keep the checkmark permanent