Ashish Mathur wrote...
Assuming you have data in range A1:B7 and the value you want data for (from
the range above) in cell A10, type the following array formula
(Ctrl+Shift+Enter)

=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A $10,ROW($A$1:$A$7)),
ROW(1:1)),2)),"",INDEX($A$1:$B$7,SMALL(IF($A$1:$A $7=$A$10,ROW($A$1:$A$7)),
ROW(1:1)),2))
....

The ISERROr call is unnecessary. If it were intended to display "" when
all matches in column A were exhausted, it'd be more efficient to use

=IF(ROW(1:1)COUNTIF($A$1:$A$7,$A$10),"",
INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1: $A$7)),ROW(1:1)),2))