how can I get excel to automatically add the section they work in

I'm assuming that section is the same as department.

Try this:

Sheet2 A1 = employee Y

=LOOKUP(2,1/SEARCH("department",Sheet1!A1:INDEX(Sheet1!A1:A15, MATCH(A1,Sheet1!A1:A15,0))),Sheet1!A1:INDEX(Sheet1 !A1:A15,MATCH(A1,Sheet1!A1:A15,0)))

Result = Department B


--
Biff
Microsoft Excel MVP


"JockW" wrote in message
...
Creating a internal phone book for a company.
Sheet 1 has the following details:
Division
Department A
employee 1 123456
employee X 123457
employee 3 123458

Department B
employee 2 987654
employee Y 987653
employee Z 987652
etc.

Sheet 2 is an alphabetical listing of all employees, regardless of which
dept. they work in.
My question is how can I get excel to automatically add the section they
work in after the other details ie:
employee 1 123456, Department A
employee 2 987654, Department B
employee 3 123458, Department A
employee X 123457, Department A
etc.
--
tia