Home

not sure which formula to use

%3CLINGO-SUB%20id%3D%22lingo-sub-680756%22%20slang%3D%22en-US%22%3Enot%20sure%20which%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680756%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20which%20formula%20to%20use%20and%20hoping%20to%20find%20some%20assistance%20here!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%202%20worksheets%20with%20columns%20for%20SSN%20(column%20A)%2C%20employee%20ID%20(column%20B)%2C%20First%20Name%2C%20Last%20Name%2C%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3EWorksheet%201%20has%20employee%20ID's%20filled%20in%20based%20on%20SSN%2C%20Worksheet%202%20does%20not.%20I%20would%20like%20to%20populate%20Worksheet%202%20Column%20B%20based%20on%20matching%20Column%20A%20%26amp%3B%20B%20from%20Worksheet%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp!%20Thanks%20so%20much%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-680756%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-680833%22%20slang%3D%22en-US%22%3ERe%3A%20not%20sure%20which%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680833%22%20slang%3D%22en-US%22%3EIn%20Sheet2!B2%2C%20you%20may%20use%20this%20formula%3A%3CBR%20%2F%3E%3DVLOOKUP(A2%2C%3CBR%20%2F%3ESheet1!A%3AB%2C%3CBR%20%2F%3E2%2C0)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-680840%22%20slang%3D%22en-US%22%3ERe%3A%20not%20sure%20which%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680840%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357584%22%20target%3D%22_blank%22%3E%40jaime77%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20Jaime!%20The%20formula%26nbsp%3BVLOOKUP%20will%20do%20the%20trick%20for%20you.%3C%2FP%3E%3CP%3EGoogle%20VLOOKUP%20to%20learn%20about%20that%20formula.%20If%20your%20excel%20is%20on%20a%20language%20other%20than%20English%2C%20the%20formula%20name%20is%20different%20but%20works%20the%20same%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E
jaime77
Occasional Visitor

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 Replies
In Sheet2!B2, you may use this formula:
=VLOOKUP(A2,
Sheet1!A:B,
2,0)

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

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies