Vlookup multiple results in one field???

[Jeremy Reynolds]

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?

 

[Peter Atherton]

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