How can I use data from excel a and Excel b ?

Excel A (total 2 rows)
Department code , Department, Department phone, Department point of contact
01 insurance 888-11-1111 manager
02 vehicle 999-111-111 super manager

Excel B (600 rows)
employee name, employee id, employe department code
john 1111 01
peter 22333 02
parker 3333 01
jim 4444 02

I want to create ouput result in excel with employee name, employee id, eployee department code, department phone, department point of contact. How can use department code values from from excel a ?

… use a join:


1 Like

Thank you…! it worked.

yepp it works) thank u)

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.