Pls help:Vlookup

[Turkelo]

Good Day

I have a data of more than 2000, which is column A B and C. and i need to transfer existing data to the new Data sheet. Here is how my spreadsheet look.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD] B
[/TD]
[TD] C
[/TD]
[/TR]
[TR]
[TD]Pretoria
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]South africa
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Johannesburg
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i need vlookup to find duplicates values in column B nd fill in column b and c
[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]c
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Johannesburg
[/TD]
[TD]011
[/TD]
[TD]110
[/TD]
[/TR]
[TR]
[TD]Pretoria
[/TD]
[TD]012
[/TD]
[TD]210
[/TD]
[/TR]
[TR]
[TD]Polokwane
[/TD]
[TD]015
[/TD]
[TD]510
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Akashwani]

Hi Turkelo and welcome to MrExcel.

To get the answer you require I think it would be best if you provided some better sample data.
Use the link in my signature to post your data and the results you would expect from the formula.

Ak