Return multiple cells if one cell is equal to other cells in a range

[saintvinni]

I want to populate cell A2 with info from all cells on the "inventory list" sheet Column A that match cell A1 from the location column on the inventory list sheet

If done correctly cell A2 would have "NA RED MAG 6" in it.
cell B2 would have 2008 Pape star 1 2000 Zin DD 2 2006 SYRAH ALISOS 1 2001 ZIN PR 1 2011 SPECIAL K 1 all listed in it.

And lastly is it possible to have the cell formatted so multiple returned cells are stacked? Example below.
2008 Pape star 1
2000 Zin DD 2
2006 SYRAH ALISOS 1
2001 ZIN PR 1
2011 SPECIAL K 1

[ArdusPetus]

Please Login or Register  to view this content.

Here it is!

Cheers,
--
AP

[Ghozi Alkatiri]

at A2
=IFERROR(INDEX('Inventory list'!$A$1:$A$195,SMALL(IF(B1='Inventory list'!$E$3:$E$195,ROW($E$3:$E$195)),1))&" "&IFERROR(INDEX('Inventory list'!$A$1:$A$195,SMALL(IF(B1='Inventory list'!$E$3:$E$195,ROW($E$3:$E$195)),2)),)&" "&IFERROR(INDEX('Inventory list'!$A$1:$A$195,SMALL(IF(B1='Inventory list'!$E$3:$E$195,ROW($E$3:$E$195)),3)),)&" "&IFERROR(INDEX('Inventory list'!$A$1:$A$195,SMALL(IF(B1='Inventory list'!$E$3:$E$195,ROW($E$3:$E$195)),4)),)&" "&IFERROR(INDEX('Inventory list'!$A$1:$A$195,SMALL(IF(B1='Inventory list'!$E$3:$E$195,ROW($E$3:$E$195)),5)),),"")

copy to all cell desired to fill