look up and match

[geno607]

I'm trying to merge two reports together. One report gives the customer id and no customer name the other contains both. I have one report on sheet 1 the other on sheet 2. I need excel to match the customer id on sheet 1 to the customer id on sheet 2 then copy the customer name on sheet 2 to the proper customer id on sheet 1. Is that even possible? This is one report I need to build out of 7 so the amount of cells could vary. any ideas where to start? I can do a find / replace but that is taking way to long. Thank you in advance.

 

[AlanY]

this is your 2 reports

Book1
	A
1	ID
2	1
3	5
4	8
5	9
6	10
7	12
Sheet1

Book1
	A	B
1	ID	Name
2	1	N1
3	2	N2
4	3	N3
5	4	N4
6	5	N5
7	6	N6
8	7	N7
9	8	N8
10	9	N9
11	10	N10
Sheet2

copy Cell B2 down

Book1
	A	B
1	ID
2	1	N1
3	5	N5
4	8	N8
5	9	N9
6	10	N10
7	12	No match
Sheet1

Cell Formulas
Range	Formula
B2	=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,FALSE),"No match")

 

[geno607]

You want this to run as a macro?

 

[Fluff]

If you want a macro, how about

Sub getNames()
   Dim Cl As Range
   Dim Ws1 As Worksheet, Ws2 As Worksheet
   
   Set Ws1 = Sheets("sheet1")
   Set Ws2 = Sheets("sheet2")
   With CreateObject("scripting.dictionary")
      For Each Cl In Ws2.Range("A2", Ws2.Range("A" & Rows.Count).End(xlUp))
         .Item(Cl.Value) = Cl.Offset(, 1).Value
      Next Cl
      For Each Cl In Ws1.Range("A2", Ws1.Range("A" & Rows.Count).End(xlUp))
         Cl.Offset(, 1).Value = .Item(Cl.Value)
      Next Cl
   End With
End Sub

 

[geno607]

You got it, that's why I love this site. It's Excellent! Thank you

 

[Fluff]

Glad we could help & thanks for the feedback