Hi
if the "database" is in excel, i would use autofilters. Click in the data
range, choose data / filter / autofilter ... click on the drop down arrow of
Phase and choose the phase you want.
Does this give you what you need?
If not, have a look at Data / Pivot Table & Pivot Chart Reports ...
http://peltiertech.com/Excel/Pivots/pivottables.htm
and
www.contextures.com/tiptech.html
Cheers
JulieD
"Flying Solo" <Flying
wrote in message
...
I have a database of employees listing various data points, such as, SSN,
DOB, Address, Salary, department, and "Phase". All employees go through 5
different "phases" within the organization, (i.e. New Hires, Offer
Lettered,
etc.). I need a worksheet function that will go to this general database
and
retrieve or "LIST" all employee names and some of their relevant data
points
(i.e. address, salary) that are at a certain phase. Example, List all
employees that are "New Hires".
The LOOKUP function does not help in this effort. I would like to avoid a
manuel copy, sort and delete process from the genearl database.