not sure which formula to use

[jaime77]

Hi All - 

I am not sure which formula to use and hoping to find some assistance here!

I have 2 worksheets with columns for SSN (column A), employee ID (column B), First Name, Last Name, etc. 

Worksheet 1 has employee ID's filled in based on SSN, Worksheet 2 does not. I would like to populate Worksheet 2 Column B based on matching Column A & B from Worksheet 1.

Help! Thanks so much in advance!

[#2]

In Sheet2!B2, you may use this formula:
=VLOOKUP(A2,
Sheet1!A:B,
2,0)

[#3]

@jaime77 

Hi, Jaime! The formula VLOOKUP will do the trick for you.

Google VLOOKUP to learn about that formula. If your excel is on a language other than English, the formula name is different but works the same way.