Can someone help me out?
I have a database of prospect email addresses (Col A) and
responsible sales person (Col B).
Let's call this Sheet 1.

Can I enter a list of rejected email addresses in Col A of Sheet 2, and
have Excel find those address in sheet 1 and return the name of the
sales person (Col B Sheet 1) into Col B of Sheet 2?