I have a sheet with a list of email addresses that is being auto-updated (more email addresses being added on a daily basis). I have a second sheet with a list of email addresses that have been contacted (marked TRUE).
I would like to add a column to the first sheet indicating which addresses have been marked as contacted, using the email addresses from the second sheet.
I can accomplish this with VLOOKUP, but since I'll be adding addresses to the second sheet, the range is a growing list.
Is it possible to have a function that checks over the growing list of contacted emails?