excel_1317
New member
- Joined
- Apr 16, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
We know that professional emails have a fixed format. I have a list of people with their names and emails and there are some people for which emails are missing. I am pasting my sample data below. But first let me explain the meaning of columns.
Column A: Means full name of the person for which we have email idColumn B & C: just split of Available full name into first name and last name
Column D: Email id of the person with full name in column A
Column E: For the names in this column, we need to get email ids
Column H: Sample result
Now basis on the Full Name(Column A) and Email Id(Column D) can we get the email id for person in Column E.View attachment Sample data.xlsx
I have originally posted this question at mrexcel forum and havent got any response. Was trying to post url to other forum but my post count is less than 5.
Column A: Means full name of the person for which we have email idColumn B & C: just split of Available full name into first name and last name
Column D: Email id of the person with full name in column A
Column E: For the names in this column, we need to get email ids
Column H: Sample result
Now basis on the Full Name(Column A) and Email Id(Column D) can we get the email id for person in Column E.View attachment Sample data.xlsx
I have originally posted this question at mrexcel forum and havent got any response. Was trying to post url to other forum but my post count is less than 5.