Home

Copy Data to Other Sheets' Columns Based on Criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-733491%22%20slang%3D%22en-US%22%3ECopy%20Data%20to%20Other%20Sheets'%20Columns%20Based%20on%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733491%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20sheet%20of%20data%20called%20Employee%20Awards%20where%3A%20Column%20A%20is%20employee%20name%2C%20Column%20B%20is%20employee%20number%2C%20Columns%20C-P%20contain%20other%20data%20relating%20to%20their%20nominations%20for%20employee%20awards.%20I%20want%20to%20I%20want%20to%20add%20demographic%20data%20for%20each%20of%20these%20employees%20which%20exists%20in%20a%20different%20workbook%20called%20Employee%20Data%20such%20as%3A%20Column%20D%20%E2%80%93%20Gender%2C%20Column%20E%20%E2%80%93%20Position%20title%2C%20Column%20F%20%E2%80%93%20Division.%20Note%20that%20Column%20A%20in%20Employee%20Data%20is%20the%20employee%20number.%20What%20formula%20can%20I%20use%20to%20find%20the%20employee%20numbers%20listed%20in%20Employee%20Awards%20in%20Employee%20Data%20and%20copy%20their%20gender%2C%20position%20title%20and%20division%20data%20across%20from%20Employee%20Data%20to%20Employee%20Awards%20in%20new%20columns%20Q%2C%20R%20and%20S%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-733491%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-733547%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20Data%20to%20Other%20Sheets'%20Columns%20Based%20on%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733547%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F369630%22%20target%3D%22_blank%22%3E%40kg-7_6%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecolumn%20Q%26nbsp%3B%3DVLOOKUP(%24B2%2C'Employee%20Data'!%24A%3A%24F%2C4%2CFALSE)%3C%2FP%3E%3CP%3Ecolumn%20R%26nbsp%3B%3DVLOOKUP(%24B2%2C'Employee%20Data'!%24A%3A%24F%2C5%2CFALSE)%3C%2FP%3E%3CP%3Ecolumn%20S%26nbsp%3B%3DVLOOKUP(%24B2%2C'Employee%20Data'!%24A%3A%24F%2C6%2CFALSE)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733551%22%20slang%3D%22en-US%22%3ERE%3A%20Copy%20Data%20to%20Other%20Sheets'%20Columns%20Based%20on%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733551%22%20slang%3D%22en-US%22%3EJust%20to%20be%20clear%2C%20these%20are%20the%20formulae%20for%20the%20row%202%20of%20your%20Employee%20Awards%20sheet%2C%20you%20can%20copy%20the%20same%20for%20rest%20of%20the%20rows.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735530%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Copy%20Data%20to%20Other%20Sheets'%20Columns%20Based%20on%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735530%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20so%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368896%22%20target%3D%22_blank%22%3E%40Kodipady%3C%2FA%3E%26nbsp%3B%3A)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
kg-7_6
New Contributor

I have an excel sheet of data called Employee Awards where: Column A is employee name, Column B is employee number, Columns C-P contain other data relating to their nominations for employee awards. I want to I want to add demographic data for each of these employees which exists in a different workbook called Employee Data such as: Column D – Gender, Column E – Position title, Column F – Division. Note that Column A in Employee Data is the employee number. What formula can I use to find the employee numbers listed in Employee Awards in Employee Data and copy their gender, position title and division data across from Employee Data to Employee Awards in new columns Q, R and S?

3 Replies

@kg-7_6 

column Q =VLOOKUP($B2,'Employee Data'!$A:$F,4,FALSE)

column R =VLOOKUP($B2,'Employee Data'!$A:$F,5,FALSE)

column S =VLOOKUP($B2,'Employee Data'!$A:$F,6,FALSE)

Highlighted
Just to be clear, these are the formulae for the row 2 of your Employee Awards sheet, you can copy the same for rest of the rows.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies