All solutions ROW Expert Solution – Excel ROW Problems

Excel - ROW Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc