Then it is easy. You will need to do a vlookup. Run a search for vlookup on
help and it should tell you everything you need to know. If you still need
help reply to this and we'll figure it out. Thanks!

Here is my example:
Worksheet1
Department Employee
HR
Accounting
"Donna" wrote:

They both have the data "department" and I want to find the manager or
employee for that department.
--
Donna


"Darrilyn" wrote:

Does anything match on the two worksheets? Do both worksheets have the
various different departments on them or do they both contain completly
separate information with nothing that matches?

"Donna" wrote:

Sorry I didn't get to complete:

Example:

worksheet 1 worksheet 2
Name of deptments VP | Manager|
Department | Employee

I would like to be able to enter a formula that in worksheet 1 would put the
manager or the employees of the department next to the department.
--
Donna


"Donna" wrote:

Hi; I am trying to find a formula that compares the data from one worksheet
to another. If the data matches I want data from another column on the second
page.

Example
1st Worksheet
Department
--
Donna