Compare Column A to Column B and return Column CSolved/Closed

Question

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

Mazzaropi · Answer

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 · Answer

Thanks Mazzaropi soved it perfectly. I was on the right track but you saved me a lot of time.

Compare Column A to Column B and return Column C

2 replies

Subscribe To Our Newsletter!