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
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
How to copy or duplicate an existing forms quiz
Olaf Nennker in Microsoft Forms on
2 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Last Value Column from Another Column in Same List
Yepitsme in SharePoint on
6 Replies
Translation problem on Transifex
Duran Hsieh in Localization Feedback on
2 Replies
Add Column Using Count
Tim Hunter in SQL Server on
0 Replies