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

ad1959 8 Posts Thursday March 6, 2014Registration date June 21, 2016 Last seen - Mar 6, 2014 at 12:56 AM - Latest reply: ad1959 8 Posts Thursday March 6, 2014Registration date June 21, 2016 Last seen
- Mar 6, 2014 at 07:25 PM
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

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Mar 6, 2014 at 04:17 AM
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
ad1959 8 Posts Thursday March 6, 2014Registration date June 21, 2016 Last seen - Mar 6, 2014 at 07:25 PM
0
Thank you
Thanks Mazzaropi soved it perfectly. I was on the right track but you saved me a lot of time.