Tracking Email Delivery Failures

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?

I bet you meant:

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

mishkarella wrote:
>
> Vlookup.
>
> If your rejected email address is in Sheet 2, cell A1 then;
>
> In Sheet 2, cell B1, enter:
>
> =VLOOKUP(A1,Sheet1!A:B,FALSE)
>
> And then copy this down.
>
> --
> mishkarella
> ------------------------------------------------------------------------
> mishkarella's Profile: http://www.excelforum.com/member.php...o&userid=35974
> View this thread: http://www.excelforum.com/showthread...hreadid=559521

--

Dave Peterson