Jul 01 2019 06:30 PM
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?
Jul 01 2019 09:00 PM
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)
Jul 01 2019 09:05 PM
Jul 02 2019 09:38 PM
Thanks so much @Kodipady :)