Excel Lookup

Dear All,

First of all I would like to introduce myself to this Forum, coz I am newbie for this site.

I am Kunal Kumar working in HR.

Now my query: I am making a sheet where I need to show data of each individual employee in a one shot with their skill sets only. Attaching a file for reference.

Suppose: Employee ABC, is having four skill sets out of 8, so when I select ABC, the excel should show only the skills which she/he has simultaneously a Graph should appear at the right side, as I did in Attachment.


Kindly answer asap with complete details, coz, this is my ongoing project, so need reply at earliest.

Regards,
Kunal Kumar