macro compare columns

[6toes2]

I have a spreadsheet col A Client ID, Col B Blank, Col C Client ID, Col 4 Salesperson ID. I want to match Col A Client ID with Col C Client ID and have the sales person populate in column B that goes with the Column A Client.
I can do the match Micro but it only tells me if there is a match and populates the client id in column B. If someone could lend a hand or point me in the right direction I would really appreciate it. The spreadsheets have about 15000 rows.
Thank you in advance.

 

[John Davis]

I have a spreadsheet col A Client ID, Col B Blank, Col C Client ID, Col 4 Salesperson ID. I want to match Col A Client ID with Col C Client ID and have the sales person populate in column B that goes with the Column A Client.
I can do the match Micro but it only tells me if there is a match and populates the client id in column B. If someone could lend a hand or point me in the right direction I would really appreciate it. The spreadsheets have about 15000 rows.
Thank you in advance.

Maybe Formula in B2 copied down:

=VLOOKUP(A2,$C$2:$D$15000,2,FALSE)

or macro:

Sub SixToesTwo()

With Range("B2:B15000")

    .Formula = "=VLOOKUP(A2,$C$2:$D$15000,2,FALSE)"
    .Value = Range("B2:B" & lr).Value
    .Replace What:="#N/A", Replacement:="", LookAt:=xlWhole
    
End With

End Sub

 

[6toes2]

Thank you so much I really appreciate it!!
I also came up with =vlookup(a2,sales,2,0) by naming my table it helped tons.
Thanks so much again, if I never posted the question I would never have gotten a answer. Have a great day!!!!

 

[John Davis]

Thank you so much I really appreciate it!!
I also came up with =vlookup(a2,sales,2,0) by naming my table it helped tons.
Thanks so much again, if I never posted the question I would never have gotten a answer. Have a great day!!!!

You're welcome. Glad it helped.