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

Hi,

in B17 and down below an array formula to be confirmed with control+shift+enter

=IFERROR(INDEX(C$2:C$12,SMALL(IF(INDIRECT(ADDRESS(2,MATCH(C$16,$D$1:$I$1,0)+3)&":"&ADDRESS(12,MATCH(C$16,$D$1:$I$1,0)+3))>0,ROW(D$2:D$12)-1),ROWS(A$1:A1))),"")

in C17 and down below:

=IF(B17<>"",VLOOKUP($B17,$C$2:$I$12,MATCH(C$16,$C$1:$I$1,0),0),"")

In the attached file please consider I'm Excel 2000 user and IFERROR is not available, so the formulae in B17 have a bigger extension.


Regards

hello Kunal,

Assume you always only have numbers for employee skills grading. See the attached.

Expand the range or you can use dynamic range. In a separate sheet you can make lookup & graph.

Kunal, did you really have to start a poll for this thread? The safe option is not to click things if you don't know what they do.

Poll closed.