I have a list of email addresses in one file and First Name and Last Name in another file. I want to match the email addresses to the names and copy them to the file which has names. What formula can I use as partial matching becomes tricky.
My data is in the following format
File 1 File 2
Column A Column A Column B Column C
Email addresses First Name Last Name I want matched email addresses here...
What formula or code should I use??
Is the information in two files or two different spreadsheets? For partial match, you need to be specific ie, I need to be able to match the first three chars.
INDEX, LOOKUP, VLOOKUP and HLOOKUP could be used. You need to provide a spreadsheet if you want specific help.
Click on star (*) below if this helps
The information is in two different files. There are two separate files for the data. I can get them in two different sheets also.
You can work with two different workbooks (files) but it is much slower than different worksheets also many functions require that the file be open - less likely if the data is in different workbooks (files).
Alright I will have the data in two different sheets and one file. But the question remains of how can I look for last names and first names in a list of email addresses...
for eg
First Name - Jason
Last Name - Simons
Email address - [email protected]
How can I look for "Simons" in the email address list that I have and get this email address out.... and I have a list of about 8000 to 10000 each.....
How about attaching a sample workbook?
I am sorry but cant attach the workbook.... it is at work... i meant this workbook is at my work place and cant share it
Perhaps others can help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks