AutoFilter is the usual way to list all the rows associated with a match to a
given value on a given column.
--
Gary''s Student - gsnu200780


"JeffH" wrote:

I have a worksheet that list all employees by employer number. I have a
second worksheet whereby I would like to enter the employer number and have
all the employees associated with that employer number listed.

How best can I do this?

Vlookup will only provide one employee. There has got to be a simple way to
do this.