Previous Topic Next Topic

Compare Column A to Column B and return Column C

[Solved/Closed]
Report
Posts
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
 -
Posts
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
 -
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
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
 145
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
Answer 2 / 2
Posts
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
 1
Thanks Mazzaropi soved it perfectly. I was on the right track but you saved me a lot of time.
Ask a question