excel MATCH function Checking if an Email Address appears in a list of addresses


Example

Let's say you need to check if an email address appears in a long list of email addresses.

checking if an email address appears in a list of addresses

Use the MATCH function to return the row number on which the email address can be found. If there is no match, the function returns an #N/A error.

=MATCH(F2,$D$2:$D$200,0)
  • The value you're retrieving data for is in cell F2
  • The range you're searching is located in $D$2:$D$200
  • You only want to know where there is an exact match (0)

But you may not care what row number the email address is on - you just want to know if it exists, so we can wrap the MATCH function to either return Yes or Missing instead:

=IFERROR(IF(MATCH(F2,$D$2:$D$200,0),"Yes"),"Missing")