I have 2 worksheet,
file 1) name, department id,
file 2) name, department id, emp id
i have file 2 contains the data for whole company and file 1 contains the small of list employee name.
I want if file 1 name and department id match with the file 2 name and department id. it should reflect emp id.
name amit rohit sachin rohit
dep id a b c d
emp id ?
name amit rohit sachin rohit rajesh manisha
dep id a b c d e f
emp id 1 2 3 4 5 6