Tracking Email Delivery Failures

M

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?
 
M

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.
 
D

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.
Click to expand...
 
Top