Jun 10 2019 08:46 AM
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!
Jun 10 2019 09:05 AM
Jun 10 2019 09:06 AM
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.