Forum Discussion
Solved
INDEX, MATCH for largest scores combined with specific criteria within the names
Hi I have this formula that brings through 5 names based on the top 5 largest scores. =INDEX('Top CV'!$C$5:$C$24,MATCH(SMALL('Top CV'!$A$5:$A$24,1),'Top CV'!$A$5:$A$24,0)) The issue is that I n...
How about this version (Excel in Microsoft 365/Office 2021/Online):
Hi OliverScheurich HansVogelaar
Quadruple Pawn I've edited your workbook to show what I'm looking for. I've added a 3rd column with age, and so the criteria is the age (in this case 21) so I want a formula that looks up the 5 names that have the lowest score but only those that are 21 (aka the criteria).
| score | age | name |
| 555 | 20 | Adam |
| 159 | 21 | Bert |
| 720 | 22 | Chris |
| 555 | 23 | Doug |
| 688 | 24 | Eve |
| 527 | 25 | Frank |
| 169 | 26 | George |
| 905 | 27 | Hubert |
| 712 | 28 | Iris |
| 485 | 21 | Joe |
| 612 | 30 | Karl |
| 658 | 31 | Lambert |
| 926 | 32 | Morton |
| 601 | 33 | Norbert |
| 133 | 34 | Oscar |
| 122 | 21 | Paul |
| 315 | 36 | Quentin |
| 149 | 21 | Rock |
| 59 | 38 | Samantha |
| 568 | 21 | Tanja |
Is this possible?
How about this version (Excel in Microsoft 365/Office 2021/Online):