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!
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.