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.

A	B	C
Pretoria
South africa

<tbody>
</tbody>

Johannesburg

<tbody>
</tbody>

i need vlookup to find duplicates values in column B nd fill in column b and c

A

B

c

<tbody>
</tbody>

Johannesburg	011	110
Pretoria	012	210
Polokwane	015	510

<tbody>
</tbody>

 

[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