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)

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.
Highlighted
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies