Data auto fill

Hi all:

Can you help me with the attached sheet.

Pls have a look at cell "O3"

It has to be an auto fill. Based on the index name I choose (from drop down) in cell "O2", the stock names should automatically get filled up from column B of the sheet.

Thanks & Regards,

try this, copied down...

=IFERROR(INDEX(OFFSET(INDEX($B$2:$B$180,MATCH($O$2,$A$2:$A$180,0)),,,COUNTIF($A$2:$A$180,$O$2),),ROW(A1)),"")

Many thanks for your help.... Appreciate it...