Find which column is my check mark

[dannwid]

Hello there, im not sure how to ask my problem, but i got the picture of it. The point is i want to know which colum is my checkmark in some arrays. This is the pict:

How do i write the formula?
Wish for the helps. Thanks

 

[dannwid]

Re: Find which colum is my check mark

This is the result that i want, Look: i4 and i5

 

[Norie]

Re: Find which colum is my check mark

Perhaps in I4 and copied down.

=INDEX($D$3:$H$3,,MATCH("v", D4:H4,0))

 

[dannwid]

Re: Find which colum is my check mark

Perhaps in I4 and copied down.

=INDEX($D$3:$H$3,,MATCH("v", D4:H4,0))

Thank you...


----
Now i have another situation, what if i have another Sheet with list of:


Software skills
Knowledge
Analytics
Accuracy
Speed


Checklist like first pic in Sheet 1, and list of above is in Sheet 2.


How do i get the score by the reference of Knowledge, Analytics, Software skills, etc. ?? (Just like how sumif works)

 

[Marcelo Branco]

Re: Find which colum is my check mark

Try

Assumes the sheet name is Sheet1 (no spaces), not Sheet 1

Sheet2 C4 copy down
=INDEX(Sheet1!D$3:H$3,MATCH("v",INDEX(Sheet1!D$4:H$8,MATCH(B4,Sheet1!C$4:C$8,0),0),0))

M.

 

[dannwid]

Re: Find which colum is my check mark

Try

Assumes the sheet name is Sheet1 (no spaces), not Sheet 1

Sheet2 C4 copy down
=INDEX(Sheet1!D$3:H$3,MATCH("v",INDEX(Sheet1!D$4:H$8,MATCH(B4,Sheet1!C$4:C$8,0),0),0))

M.

Works like a charm, Thanks A lot Marcelo

 

[Marcelo Branco]

Re: Find which colum is my check mark

You are welcome. Thanks for the feedback.

M.