Help identifying whether Sheet1!A* = Sheet2!A* and then populating with Sheet2!C*

[garyarubin]

I have ~50,000 usernames in Column A on Sheet1. Many of those usernames repeat. On Sheet2, I have the same usernames in Column A, followed by their employee IDs in Column B. But on Sheet2, there are no repeats. I want to copy over the IDs from Sheet2 into the corresponding place in Sheet1. Essentially, I want to to say: if any cell on Sheet1!Column A = any cell on Sheet2!Column A, then copy the Sheet2!Column C value from the same row into that same row in Sheet1!Column C. Thanks!

 

[kevin9999]

You probably just need a simple Vlookup(). Your description is a bit confusing, firstly you say you want the employee IDs from column B, but then you say you want the value brought from column C Anyhow, see if this gives you a clue:

Book1
	A	B
1	UserID	Emp ID
2	user 1	146
3	user 2	305
4	user 3	330
5	user 4	689
6	user 5	111
7	user 6	158
8	user 7	405
9	user 8	894
10	user 9	407
11	user 10	275
12	user 1	146
13	user 2	305
14	user 3	330
15	user 4	689
16	user 5	111
17	user 6	158
18	user 7	405
19	user 8	894
20	user 9	407
21	user 10	275
Sheet1

Cell Formulas
Range	Formula
B2:B21	B2	=VLOOKUP(A2,Sheet2!A:B,2,FALSE)

Book1
	A	B
1	UserID	Emp ID
2	user 1	146
3	user 2	305
4	user 3	330
5	user 4	689
6	user 5	111
7	user 6	158
8	user 7	405
9	user 8	894
10	user 9	407
11	user 10	275
12
Sheet2

 

[garyarubin]

This is excellent, thank you. Sorry for the typo in my original.

 

[kevin9999]

This is excellent, thank you. Sorry for the typo in my original.

You're welcome, thanks for the feedback