Vlookup multiple results in one field???
 

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?

Vlookup multiple results in one field???
 

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?
.