Forum Discussion
Rafaelbf1985
Jan 12, 2021Copper Contributor
Sheet to search for name on other tabs
Hi guys, I've been trying to create an attendance sheet for the school I work for, but I didn't manage to achieve what I need using the little I've seen around or found on the internet. I hope someon...
SergeiBaklan
Jan 13, 2021Diamond Contributor
That could be like
=IF(ISNA(MATCH($B4,Table_1[[#All],[Column2]],0)),"-","x")
but with repeated names that won't work correctly (e.g. you have two Andrea)