Forum Discussion

jaime77's avatar
jaime77
Copper Contributor
Jun 10, 2019

not sure which formula to use

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!

 

excel
Formulas and Functions

2 Replies

  • Celia_Alves's avatar
    Celia_Alves
    MVP
    Jun 10, 2019

    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.

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jun 10, 2019
    In Sheet2!B2, you may use this formula:
    =VLOOKUP(A2,
    Sheet1!A:B,
    2,0)