Hi,
I was using an Index Match Array formula to get multiple results according to one criteria.
In this formula, I am able to get the list of names for location "XX". That is A, D, E.
{=INDEX($A$2:$A$6,SMALL(IF(ISNUMBER(MATCH($D$2:$D$6,Location,0)),MATCH(ROW($D$2:$D$6),ROW($D$2:$D$6)),""),ROWS($E$1:E1)))}
<tbody>
</tbody>
Now, I have come across a scenario where I need to use two criteria. That is, Qualification and Location.
For example, I need the Names where the qualification is "AAA" and location is "XX".
Can someone help me in modifying the formula to get the above result.
Thanks in advance
Regards
Deepak
I was using an Index Match Array formula to get multiple results according to one criteria.
In this formula, I am able to get the list of names for location "XX". That is A, D, E.
{=INDEX($A$2:$A$6,SMALL(IF(ISNUMBER(MATCH($D$2:$D$6,Location,0)),MATCH(ROW($D$2:$D$6),ROW($D$2:$D$6)),""),ROWS($E$1:E1)))}
Name | Age | Qualification | Location |
A | 21 | AAA | XX |
B | 21 | AAA | YY |
C | 25 | BBB | ZZ |
D | 21 | AAA | XX |
E | 20 | BBB | XX |
<tbody>
</tbody>
Now, I have come across a scenario where I need to use two criteria. That is, Qualification and Location.
For example, I need the Names where the qualification is "AAA" and location is "XX".
Can someone help me in modifying the formula to get the above result.
Thanks in advance
Regards
Deepak