I'm trying to use Google Sheets to make a register-type file. In this file, I have a column of names of people that should be attending and another column where I write the names of the people I have already seen, in separate cells, so I can track other things like time they arrived and food preferences etc. I'm trying to create a FIND statement to search for the names to automatically cross people off the list that have arrived. This is what I've tried:
And it gives the error:
An array value could not be found.
I've managed to make it work by using:
but that literally only searches one cell, which is not helpful at all.
Is there any way I can search a range of field for the phrase in another field? If you want to see an example of what I need, here's a link.