Previous Topic Next Topic

Compare Column A to Column B and return Column C

Solved/Closed
ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 - Mar 6, 2014 at 12:56 AM
ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 - 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

2 replies

Answer 1 / 2
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Mar 6, 2014 at 04:17 AM
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
0
Answer 2 / 2
ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 1
Mar 6, 2014 at 07:25 PM
Thanks Mazzaropi soved it perfectly. I was on the right track but you saved me a lot of time.
0