Tracking Email Delivery Failures

[mheimerl]

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?

 

[mishkarella]

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.

 

[Dave Peterson]

I bet you meant:

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

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.