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