need formula for a match function wrapped inside ... Question: Need formula for

Question

need formula for a match function wrapped inside ... Question: Need formula for a MATCH function wrapped inside t... Need formula for a MATCH function wrapped inside the =INDEX function to find the one consultant that is proficient in all languages (Row Ten) in this excel sheet. To be displayed in S17. In this case Jang, Lin (A15) Name must appear in S17.

HOM INERT PACE LAYOUT FORMULAS DATA REME E ipbaard 517 -/ .fr :0DENTallelIVB)RTML 5))MATCHry.TableiINB)RTML 5]. Name)) Consultants Summary ng Lin 385285 14

Explanation / Answer

The formula in cell S17 will be =INDEX(A11:A29,MATCH(7,L11:L29,0))

Basically the formula will look for value 7 in the column L (range L11 to L29), match that value with the values in column L and return the corresponding value of column A (range A11 to A29)

The reason it will look for value 7 is that there are seven languages in total and the consultant who knows all the languages will have a count of 7 against his name in column L (in this case Jang,Lin).

Hope this helps you, thanks

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.