**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.*