• 513K Members
• 1,775 Online
• 611K Conversations

New Contributor

# Copy Data to Other Sheets' Columns Based on Criteria

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

# Re: Copy Data to Other Sheets' Columns Based on Criteria

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)

# RE: Copy Data to Other Sheets' Columns Based on Criteria

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

# Re: RE: Copy Data to Other Sheets' Columns Based on Criteria

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