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.
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")
