, Good morning.
The suggested formula answers what you requested in your first message.
Now, your remark leaves me in doubt about what you really need.
"...But couldn't perform an entire search in all the rows of list 1 against all the rows in list2. Is there any way to do it? ...
What do you mean by that?
You can have twenty thousand rows of names to check in worksheet1, against another forty thousand names in worksheet2.
You simply adapt the intervals in the formula for this.
Just copy the formula in column B of worksheet 1 to the last line of the existing name.
Remember, you have to have the individual answer for each name whether it exists or not.
If you had sent us your file the solution would have been in your hands for a long time.
Please save your Excel file to a free website, www.sendspace.com or ge.tt and place the download link here.
So it will be possible for us to help you more effectively.
Belo Horizonte, Brasil