Matching email addys with names on different lists

**BrianSells** · 07-14-2011, 01:55 PM

I have a customer list of around 6000 names and addresses. I have a separate list of names with email addresses. Is there a way for me to do some sort of lookup function to get the email addresses pulled from the one list and put to the corresponding names on the other list. I need it to check for both first and last names due to the fact that I have a lot of duplicate last names. Thanks in advance for any help on this.

Brian Sells

**NBVC** · 07-14-2011, 02:05 PM

So assuming the first and last names are separate columns, then something like:

=INDEX(Sheet2!$C$2:$C$6000,MATCH(1,INDEX((Sheet2!$A$2:$A$6000=A2)*(Sheet2!$B$2:$B$6000=B2),0),0))

copied down

where Sheet2!A2:C6000 is the lookup table and you are maching up A2 and B2 of active sheet to columns A and B of Sheet 2 to get column C addresses.

**BrianSells** · 07-14-2011, 03:31 PM

Ok I am still having trouble. I have on Sheet 1 A(first names) B(last names). There are 7000 names. On Sheet 2 A(first names) B(last names)and C(email addresses). There are only 6241 email addresses due to dropped customers and multiple name entries. I need to get the 6241 email addresses with the corresponding names on sheet 1. It's not really feasible for me to sort the lists because of other factors. Is it possible to do this?

**NBVC** · 07-14-2011, 04:00 PM

Did I mention sorting?

adjust the formula ranges to account for 6241 instead of 6000

**BrianSells** · 07-16-2011, 02:36 PM

NBVC......thanks for your help.........Got it straightened out with that formula........I only mentioned the sorting because it had occurred to me that I might be able to do that. Anyway, thanks again for your help!