Searching/Filtering by multiples email addresses

[Haley_Lopez]

Hi, if I have a spreadsheet with a long list of emails, and I need to search those email on my base, is there a way to search/filter all emails at one time or do I need to search 1 by 1? I've tried to filter by emails address and pasting all the address in the "contains" value but it doesn't bring anything up, same with the simple search?

Thank you!

[TheTimeSavingCo]

Hmm, you could try:
1. Create a Long Text field called "Emails to find" or something
2. Copy the list of emails you need to find
3. Click the header of the "Emails to find" field and paste in the emails
3. Create a Formula field with the formula

IF(
  FIND(
    Email,
    {Emails to find}
  ),
  "Email found"
)

Depends on what you're trying to do though; lemme know if this doesn't work for you