This is a vlookup-type of function which will display multiple results for
your lookup/query:

=IF(ROWS(B$1:B1)<=COUNTIF($A$1:$A$20,$E$1),INDEX($B$1:$B$20,SMALL(IF($A$1:$A$20=$E$1,ROW($A$1:$A$20)-ROW($E$1)+1),ROWS(B$1:B1))),"")
This is committed with Ctrl+Shift+Enter (not just Enter)

Notice:
In this example, the data is in column A and column B, and the criteria that
you are 'looking up' is in cell E1.

As an alternative, you can try these
=IF(ROWS(E$1:E1)<=COUNTIF(A$1:A$20,E$1),SMALL(IF(A$1:A$20=E$1,B$1:B$20),ROWS(E$1:E1)),"")

=IF(ROWS($1:1)>COUNTIF($A$1:$A$20,$E$1),"",INDEX($B$1:$B$20,SMALL(IF(($A$1:$A$20=$E$1),ROW($A$1:$A$20)),ROWS($1:1))))

=IF(ISERR(SMALL(IF(FREQUENCY(IF($A$1:$A$20=E$1,MATCH($B$1:$B$20,$B$1:$B$20,0)),MATCH($B$1:$B$20,$B$1:$B$20,0))>0,ROW(INDIRECT("1:"&ROWS($B$1:$B$20)))),ROWS($1:1))),"",INDEX($B$1:$B$20,SMALL(IF(FREQUENCY(IF($A$1:$A$20=E$1,MATCH($B$1:$B$20,$B$1:$B$20,0)),MATCH($B$1:$B$20,$B$1:$B$20,0))>0,ROW(INDIRECT("1:"&ROWS($A$1:$A$20)))),ROWS($1:1))))
(try to figure this out only if you get bored easily)

Regards,
Ryan---