I didn't give you exact locations for each piece of information because I
figured that if I had the proper formula, I would be able to adjust the
formula a little here and there to make it appropriate to my sheet, but I'm
lost with this formula so let me give you the exact information.

Workbook "Packaging" Worksheet "Employee List" Column A has the employees
numbers.
Workbook "Packaging" Worksheet "Employee List" Column C has the employee's
job title.
Workbook "Meeting" Worksheet "Operators" Column A needs to have the employee
number.(which in turn I will do a VLOOKUP to retrieve the name that is
associated with that number which will be listed in column B)
Workbook "Meeting" Worksheet "Laborers" Column A needs to have the employee
number.
Workbook "Meeting" Worksheet "Forklift Drivers" Column A needs to have the
employee number.

Thank you.

"Ragdyer" wrote:

Say your list is on Sheet1, from A2 to B100, with employee numbers in Column
A and job titles in Column B.

On Sheet 2, job title is in A1 - Operator
Sheet2 - A1 = Laborer

Each succeeding sheet will have job title in A1 of that sheet.

In A2 of *each* sheet, enter this *array* formula:

=IF(COUNTIF(Sheet1!B$2:B$100,A$1)=ROWS($1:1),INDE X(Sheet1!A$2:A$100,SMALL(I
F(Sheet1!B$2:B$100=A$1,ROW($1:$99)),ROWS($1:1)))," ")

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
You *must also* use CSE when revising the formula.

*After* the CSE entry, copy the formula down as many rows as you anticipate
that you might need.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Troy2006" wrote in message
...
As it says below I need sheet 2 to list the operators from the employees
that
are listed on sheet 1. Example:
Sheet 1
#284 Operator
#178 Forklift Driver
#318 Operator
#67 Laborer
#211 Laborer
#354 Operator
#119 Forklift

Sheet 2 needs to find the value of "Operator" from sheet 1 and return the
employee #s to sheet 2.

Sheet 3 needs to find the value of "Laborer" from sheet 1 and return the
employee #s to sheet 3.

"bigwheel" wrote:

We can see you have a problem with the high turn over ratio of employees
but
do you have a problem with Excel that we can help with?

"Troy2006" wrote:

I have a problem.

We have a quite high turn over ratio so employees are moving into
different
jobs constantly.
I have a list of employees in column A on Sheet 1 in alphabetical
order. As
different jobs are offered to different employees this list will be
changed.
I have a list of their respective job titles on column B sheet 1.
In sheet 2 I would like to have all of the operators listed.
In sheet 3 I would like to have all of the laborers listed.
In sheet 4 I would like to have all of the lift truck drivers listed.
And so on and so forth.