Returning Values

[Guest]

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.

 

[Guest]

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?

 

[Guest]

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.

 

[Ragdyer]

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),INDEX(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.

 

[Guest]

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]

Assume as before:
A1 on *each* sheet in the Meeting WB will have the job title entered
*exactly* as it is entered in the "Employee List" sheet.
I noticed that your OP used singular titles, whereas your sheet names were
plural!
The sheet names aren't important, but make sure that A1 and your datalist
titles are *identical*.

Assume there are column headers in Row1 of the "Employee List" sheet, so
data is from A2 to C100.

Enter this *array* formula on *each* sheet of the "Meeting" WB, in A2 if you
wish:

=IF(COUNTIF('[Packaging.xls]Employee
List'!C$2:C$100,A$1)>=ROWS($1:1),INDEX('[Packaging.xls]Employee
List'!A$2:A$100,SMALL(IF('[Packaging.xls]Employee
List'!C$2:C$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. Also, you must use CSE when
revising the formula.

*After* the CSE entry, copy down as many rows as you think you'll need in
order to display all possible returns.