In this example all names assigned to 100 are being retrive:
Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style=";">name</td><td style=";">status</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">0</td><td style=";">ANNA</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">100</td><td style=";">jhun</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">0</td><td style=";">liza</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">2</td><td style=";">roy</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">3</td><td style=";">mary</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">100</td><td style=";">mama</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">12</td><td style=";">ANNA</td></tr><tr><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">100</td><td style=";">ANNA</td></tr><tr><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">100</td><td style=";">PAPA</td></tr><tr><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">44</td><td style=";">ANNA</td></tr><tr><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">44</td><td style=";">ANNA</td></tr><tr><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr><td style="color: #161120;text-align: center;">14</td><td style=";">LARGEST</td><td style="text-align: right;;">100</td></tr><tr><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;"></td><td style=";">jhun</td></tr><tr><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;"></td><td style=";">mama</td></tr><tr><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;"></td><td style=";">ANNA</td></tr><tr><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;"></td><td style=";">PAPA</td></tr></tbody></table>
Sheet2
<table rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" cellpadding="2.5px" width="85%"><tbody><tr><td style="padding:6px">
Worksheet Formulas<table rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px" width="100%"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th style=" background-color: #DAE7F5;color: #161120" width="10px">B14</th><td style="text-align:left">=LARGE(
$A$2:$A$12,1)</td></tr></tbody></table></td></tr></tbody></table>
<table rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" cellpadding="2.5px" width="85%"><tbody><tr><td style="padding:6px">
Array Formulas<table rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px" width="100%"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th style=" background-color: #DAE7F5;color: #161120" width="10px">B15</th><td style="text-align:left">{=IFERROR(
INDEX($A$2:$C$13, SMALL(IF($B$14=$A$2:$A$13, ROW($A$2:$A$13)-MIN(ROW($A$2:$A$13))+1, ""), ROW(B1)),COLUMN(B1)),"")}</td></tr><tr><th style=" background-color: #DAE7F5;color: #161120" width="10px">B16</th><td style="text-align:left">{=IFERROR(
INDEX($A$2:$C$13, SMALL(IF($B$14=$A$2:$A$13, ROW($A$2:$A$13)-MIN(ROW($A$2:$A$13))+1, ""), ROW(B2)),COLUMN(B2)),"")}</td></tr><tr><th style=" background-color: #DAE7F5;color: #161120" width="10px">B17</th><td style="text-align:left">{=IFERROR(
INDEX($A$2:$C$13, SMALL(IF($B$14=$A$2:$A$13, ROW($A$2:$A$13)-MIN(ROW($A$2:$A$13))+1, ""), ROW(B3)),COLUMN(B3)),"")}</td></tr><tr><th style=" background-color: #DAE7F5;color: #161120" width="10px">B18</th><td style="text-align:left">{=IFERROR(
INDEX($A$2:$C$13, SMALL(IF($B$14=$A$2:$A$13, ROW($A$2:$A$13)-MIN(ROW($A$2:$A$13))+1, ""), ROW(B4)),COLUMN(B4)),"")}</td></tr></tbody></table>
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself</td></tr></tbody></table>