Vlookup multiple results in one field???

  • Thread starter Thread starter Jeremy Reynolds
  • Start date Start date
J

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?
 
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
 
Back
Top