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
Highlighted
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
Highlighted

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