|I would suggest using IF(ISNA(... instead of IF(ISERROR(...|
Using ISERROR can mask other errors, such as #REF, while #N/A is the error we are actually looking for if there isn't a match.
For example, let's say that the value in F1 can be found in A1:A2000. We should expect a Y, correct?
Now, let's say I make a typo when entering the formula and use a col_num argument of 2 when there is only 1 column in A1:A2000.
The VLOOKUP will return a #REF error and the ISERROR will be TRUE so the formula will return "" even though the value in F1 was found.
However, if I use
I will get a Y since the ISNA is looking for a specific error (#N/A) which will be returned if the value in F1 is not found.
BTW...I prefer to use 0 instead of FALSE just to save keystrokes.
Another option is to use the following formula which will return F or G so not only will you know if the email address is found, but you'll know which column it was found in.
Drag this down to the bottom of your list in Column A
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.