Match Names to Email Address

mabo · Sep 3rd 2006

Hi Guys,

I have attached an example of some data I have.
Basically I have a list of email addresses in column A and I have a list of names in column B. The list of emails on the actual version is about 2000 and the names about 800. What I need to do is match the email addresses with the names. If possible to put them next to the name. As stated there are a lot more emails than names. Its either this way or going through 800 names searching for an email address for each.........not thanks, not sure if this is possible, did a search but didn't find anything relevant.

There is also a catch, if possible I would like not to sort the names in any way, just leave it as is. Any suggestions ??

Cheers.

Bob Phillips · Sep 3rd 2006

Re: matching 2 columns together

Seems to work

=IF(COUNTIF($A$1:$A$10,SUBSTITUTE(B1," ",".")&"*")>0,INDEX($A$1:$A$10,
MIN(IF(SUBSTITUTE(B1," ",".")=LEFT($A$1:$A$10,LEN(B1)),ROW($A$1:$A$10)))),"")

which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter.

Dave Hawley · Sep 4th 2006

Re: matching 2 columns together

Another way without an array formula

=INDEX($A:$A,MATCH(SUBSTITUTE(B1," ",".")&"*",$A:$A,0),1)

Where email addresses are in Column "A" and Names in Column "B".

maree89 · Feb 5th 2014

Re: matching 2 columns together

Hi there, I found this formula very helpful, however I have a slight problem .....If there is more than one employee with the same 'first name' on the list (Column B), it will pick up on the specified first name on the email list (Column A) alphabetically and then pick up on the incorrect email address that has the correct first name, but last name does not match.

=INDEX($A:$A,MATCH(SUBSTITUTE(B1," ",".")&"*",$A:$A,0),1)

Can someone please amend the above formula for me.

Appreciate any help!

smuzoen · Feb 5th 2014

Re: Match Names to Email Address

Welcome to the forum maree89. Please do not ask new questions in existing threads - please start a new thread and if you feel this thread is pertinent to your question then just add a link in your post to this thread. This thread has been closed. You will need to repost your question as a new post in the forum.

Match Names to Email Address

Participate now!

Share