Extract multiple data matching with input

[excel_learner]

I have set of data in table, I want to extract/display in a formatted report in muliple rows the data matching with the input.

Lets say i have three column Name, Description and holding, where name is repeatitive but different Description and holding. I want to extract all by inputing the selected name from the list the corresponding data from description and holding.

I have attached the sheet for easy reference.

Kindly assist.

thanks

[Admin]

Hi,

In B18 and copied down & across,

=IFERROR(INDEX(B$3:B$12,SMALL(IF($A$3:$A$12=$E$15, ROW($B$3:$B$12)-ROW($B$3)+1),ROWS(B$18:B18))),"")

Confirmed with CTRL + SHIFT + ENTER

HTH