Match customer number to customer name

[Johnnyb]

Hi,

I have a sheet (sheet1) with 2 columns, column 1 has customer name wit
duplicates and column 2 has customer number with duplicates. I hav
removed using a formula all of the duplicated customer names on anothe
sheet (sheet2). How can i match the customer number from sheet 1 to th
non duplicated customer name on sheet 2?

Any help would be great,

Regards,

Johnny

 

[JulieD]

Hi Johnny

use VLOOKUP
in column B sheet 2 type
=VLOOKUP(A1,Sheet1!$A$1:$B$100,2,0)
where Sheet1!$A$1:$B$100 contains your original data

Cheers
JulieD

 

[Johnnyb]

That's great Julie,

Thanx.

 

[JulieD]

glad to assist