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.
<tbody>
</tbody>
<tbody>
</tbody>
i need vlookup to find duplicates values in column B nd fill in column b and c
<tbody>
</tbody>
<tbody>
</tbody>
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>