Lookup return multiple results

[EssKayKay]

Is it possible to have a lookup table return numerous answers?

Example:

Lookup Table
5/4/2005 Dog
5/5/2005 Cat
5/5/2005 Mouse
5/6/2005 Pig

Keyin Lookup = 5/5/2005

Returns:
Cat, Mouse

Thanks,
SKK

 

[Krishnakumar]

Try,

=IF(A2="","Yes",IF(ROWS($A$1:A1)+1-MATCH(BigStr,$C$2:C2)<=COUNTIF($A$2:$A$6,LOOKUP(BigStr,$C$2:C2)),INDEX($B$1:$B$6,SMALL(IF($A$2:$A$6=LOOKUP(BigStr,$C$2:C2),ROW($B$2:$B$6)),ROWS($A$1:A1)+1-MATCH(BigStr,$C$2:C2))),""))

HTH

 

[Fin Fang Foom]

Once again thank You.