compare 2 column with other worksheet

February 11, 2011 at 11:31:20
Specs: Windows XP
Hi,
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.
e.g
file 1
name amit rohit sachin rohit
dep id a b c d
emp id ?
file 2
name amit rohit sachin rohit rajesh manisha
dep id a b c d e f
emp id 1 2 3 4 5 6

See More: compare 2 column with other worksheet

Report •

#1
February 11, 2011 at 12:47:51
Please read the How To referenced in the following line and then repost your data so that we can tell what belongs in which column.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question