Associates names by Looking up skill Type

[Krishna Chaitanya G]

Hi All,

By selecting type of skill, I should get the list of associates names, who has that skill.

Vlookup gives only first associate name with that skill.

How can we view all associates names with that skill.

Regards
Krishna

 

[Luke M]

Check this out:
http://office.microsoft.com/en-us/e...ultiple-corresponding-values-HA001226038.aspx

 

[Somendra Misra]

Hi Krishna,

Welcome to the forum.

Consider the uploaded file. Is this what are you after?

Just advise if any issue.

Regards,