Jeremy

Lookup formulas only return one value. Try using the
Autofilter option (Data, Filter, Auto Filter) When you
select the rating from the drop down list in column o the
other records will be hidden.

Regards
Peter
-----Original Message-----
Have a spreadsheet where we have the following:

column O: The skill set Rating (A,H,L)

column P: =VLOOKUP(O9,'Active Employee Listing'!
$B$2:$E$101,4)

So basically, someone goes into the spreadsheet and says
I want to
know every employee with skill set rating "A". Types that
in column O9
and then in P9 it displays a name from the Active
Employee Listing
(which lists each employee and their corresponding skill
set rating).

Problem:

We have several employees with the same skill set rating.
So when
someone types in "A" we want the next column with the
vlookup code to
display a list of all the employee names that match the
skill set
rating. NOT the first one it comes to in the vlookup
process.

Is there a way to do this?
.