Menu
Ask a question Report

Compare Column A to Column B and return Column C [Solved/Closed]

Posts
8
Registration date
Thursday March 6, 2014
Last seen
June 21, 2016
 - - Latest reply: ad1959
Posts
8
Registration date
Thursday March 6, 2014
Last seen
June 21, 2016
 - Mar 6, 2014 at 07:25 PM
Excel Ask a question Report
Hello,
I have spreadsheet with names in Column A, phone numbers in Column B.
Column C has the same names in different order.
How can I have column D display the correct phone number ?
It is a largish spreadsheet (188 rows) can anyone help in simplifying my requirements.
Can any one help

Thanks in advance


A B C D
Name Phone Name Phone
ab 12 ij 910
cd 34 mn ?
ef 56 kl
gh 78 ab
ij 910 gh
kl 1112 cd
mn 1314 ef
See more 

2 replies

Report Respond to Mazzaropi
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
0
Thank you
ad1959, Good morning.

Try to use it:
D2 --> =VLOOKUP(C2,$A$2:$B$8,2,FALSE)
Copy down this formula.

Adjust the range to your reality.

Please, tell us if it worked for you.
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
Report Respond to ad1959
Posts
8
Registration date
Thursday March 6, 2014
Last seen
June 21, 2016
0
Thank you
Thanks Mazzaropi soved it perfectly. I was on the right track but you saved me a lot of time.
Ask a question