index and match

LadyMo

New Member
Joined
Oct 30, 2018
Messages
1
I have been sitting for hours trying to figure out the formula for one of the entries on my homework!! I NEED HELP BAD!!! What is the index-match formula to get the name of the consultant who knows all of the languages? Thanks in advance!!

Business Analyst TableSummary:
NameGenderAgeYrsJavaPythonC#RPHPJava- ScriptRubyCountTotal count of women6
Bhua, LiM212YNYYNNN3Total count of men12
Kadafi, KimM224YYYNYNN4Average age of women29.83333
Kidd, LauraF231YYNNYYY5Average age of men31.33333
Sea, TylerM243YNNNYYN3Median age of all consultants30.58333
Jang, LinF255YYYYYYY7Average years of experience7.5
White, DanzelM253YYYNYYN5Total years of Java experience (all consultants)60
Chavez, JuanitaF264NYNYYNN3Consultant who knows all languages#N/A
Naik, ChandanaF289YNNYNNY3
Biagi, JohnM2911NYNYYNY4
Goldsmith, EdM318NYYNNNY3
Hatt, JerimiahM325YNNYYNY4
Santos, CarlosM327NNYNNNY2
Sosa, FlowerF3210NYYYNYY5
Dan, JakeM3419NYNNYYN3
Harley, JimM389NNNNYYY3
Diaz, JorgeM3815YYYYYYN6
Smith, KylieF457NYYYYNN4
Brown, FredM5013YNNYYYY5

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="4"><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

wilsjohn

New Member
Joined
Nov 15, 2018
Messages
11
INDEX($A$2:$L$20,MATCH(7,$L$2:$L$20,0),1)

Assuming the cell with "NAME" is in A2 this will work.

Looks up who knows 7 languages hence "7". and looks in column 1.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,575
Messages
5,523,681
Members
409,531
Latest member
wo1f

This Week's Hot Topics

Top