Match customer number to customer name

  • Thread starter Thread starter Johnnyb
  • Start date Start date
J

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
 
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
 
Back
Top