Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula that matches names in two sheets and when a match occurs on sheet 1, it inputs the phone number from the same row of the match on sheet 1 to sheet 2.
Solved by B. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
18/04/2018 - 06:07
Hi
User
18/04/2018 - 06:07
Hello
Excelchat Expert
18/04/2018 - 06:07
It's pleasure to help you today.
User
18/04/2018 - 06:07
I look forward to it
Excelchat Expert
18/04/2018 - 06:08
Please share sample info in the preview.
Excelchat Expert
18/04/2018 - 06:09
Hi, there?
User
18/04/2018 - 06:13
okay
Excelchat Expert
18/04/2018 - 06:13
Ok. I am working on it. I will get the phone numbers.
Excelchat Expert
18/04/2018 - 06:15
=iferror(VLOOKUP(E2,'Current Sales Reps'!A:B,2,false),"")
Excelchat Expert
18/04/2018 - 06:15
Please check F2 cell.
User
18/04/2018 - 06:16
I copied your formula to my spredsheet and it seemd to work
User
18/04/2018 - 06:16
what am i checking on F2?
Excelchat Expert
18/04/2018 - 06:16
The above formula is for F2 cell. It is copied over for other cells.
Excelchat Expert
18/04/2018 - 06:16
Some cells does not have phone numbers.
Excelchat Expert
18/04/2018 - 06:17
So, to avoid error, i have used iferror formula.
User
18/04/2018 - 06:17
Yes, I expected some to not return results
Excelchat Expert
18/04/2018 - 06:17
Ok. Great.
Excelchat Expert
18/04/2018 - 06:17
Please visit Got It Pro for new queries. Have great day ahead.
User
18/04/2018 - 06:17
Can you give me a couple minutes to spot check the accuracy?
Excelchat Expert
18/04/2018 - 06:17
Sure.
Excelchat Expert
18/04/2018 - 06:17
I am availabl.e
Excelchat Expert
18/04/2018 - 06:17
Please check it.
User
18/04/2018 - 06:18
awesome!
User
18/04/2018 - 06:18
great.. thank you!
Excelchat Expert
18/04/2018 - 06:18
Thank you.
User
18/04/2018 - 06:18
cannot believe it was that fast
User
18/04/2018 - 06:19
you are a darn genious!
Excelchat Expert
18/04/2018 - 06:19
It is very simple.
User
18/04/2018 - 06:19
for you
User
18/04/2018 - 06:19
Can i ask another question..
Excelchat Expert
18/04/2018 - 06:20
There is a direct formula for these type of problems.
Excelchat Expert
18/04/2018 - 06:20
We can support one question per session.
User
18/04/2018 - 06:20
OKay
Excelchat Expert
18/04/2018 - 06:20
It is as per our policies.
User
18/04/2018 - 06:20
essentially doing the same thing... just different columns
Excelchat Expert
18/04/2018 - 06:20
Please visit Got IT Pro for new queries.
Excelchat Expert
18/04/2018 - 06:21
We can provide 24 * 7 support.
User
18/04/2018 - 06:21
Thanks again
Excelchat Expert
18/04/2018 - 06:21
Sure.
Excelchat Expert
18/04/2018 - 06:21
Please let me know.
Excelchat Expert
18/04/2018 - 06:21
What other column to be referred?
Excelchat Expert
18/04/2018 - 06:21
I can explain the formula to understand better
User
18/04/2018 - 06:21
Please
Excelchat Expert
18/04/2018 - 06:21
=iferror(VLOOKUP(E2,'Current Sales Reps'!A:B,2,false),"")
Excelchat Expert
18/04/2018 - 06:21
Please refer Vlookup
Excelchat Expert
18/04/2018 - 06:22
=vlookup(search_text,search range,column reference output, false)
Excelchat Expert
18/04/2018 - 06:23
Search range will have always the first where the search text is present.
Excelchat Expert
18/04/2018 - 06:23
In this case it is name. So, i have choosen A:B.
Excelchat Expert
18/04/2018 - 06:23
If you have more data, A:C or A:D
Excelchat Expert
18/04/2018 - 06:23
But, A should have name
User
18/04/2018 - 06:23
GOT IT!
Excelchat Expert
18/04/2018 - 06:24
If your name contains in column B, then you have to choose it as B:C.
User
18/04/2018 - 06:24
or B:D in that case
Excelchat Expert
18/04/2018 - 06:24
Info required will be always right side of seach column text.
Excelchat Expert
18/04/2018 - 06:25
Phone number can't be B.
User
18/04/2018 - 06:25
right... "B" would have to be the name I am trying to match
User
18/04/2018 - 06:25
However in this case it will be A:?
Excelchat Expert
18/04/2018 - 06:25
Yes.
User
18/04/2018 - 06:25
"?" is for what i am trying to import based on matching the name in A
Excelchat Expert
18/04/2018 - 06:25
If Name is there in B and phone number can't be in A.
Excelchat Expert
18/04/2018 - 06:26
It can be in C, D, E, etc.
Excelchat Expert
18/04/2018 - 06:26
The result column you are looking for is always on right side of search column.
Excelchat Expert
18/04/2018 - 06:26
It is the fundamental priniciple of vlookup.
User
18/04/2018 - 06:26
thank you again
User
18/04/2018 - 06:26
cheers!
User
18/04/2018 - 06:27
NICE!
Excelchat Expert
18/04/2018 - 06:27
Thank you.
User
18/04/2018 - 06:27
THank yoU!
Excelchat Expert
18/04/2018 - 06:27
And the number is the number from search column.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.