Find multiple products in Matrix

[Kjuby]

Hi guys,
I have the following two excel sheets:
Sheet A
| id |
| 1 |
| 2 |
| 3 |

Sheet B
| Product | id | 
| Table    | 2 |
| Book     | 2 |
| Phone   | 1 |
|Table     | 1 |
| Phone   | 2 |
| Phone   | 3 |

What I am trying to achieve is this:
._extend Sheet A
| id 1 | |  id 2 |    id 3 | 
| Table | Table |  Phone
           | Book  |
           | Phone |



Could you please assist me? 
An excel formula only solution would be best. (without VBA)

Best,
Kjuby

[neopa]

Hi Kjuby,

see B2 or G2:

Sheet A

	A	B	C	D	E	F	G	H	I
1	id					id	1	2	3
2	1	Phone	Table				Phone	Table	Phone
3	2	Table	Book	Phone			Table	Book
4	3	Phone						Phone
5

Formeln der Tabelle

Zelle Formel B2 =IFERROR(INDEX('Sheet B'!$B:$B,AGGREGATE(15,6,ROW(G$2:G$99)/('Sheet B'!$C$2:$C$99=$A2),COLUMN(A1))),"") G2 =IFERROR(INDEX('Sheet B'!$B:$B,AGGREGATE(15,6,ROW(G$2:G$99)/('Sheet B'!$C$2:$C$99=G$1),ROW(G1))),"")

Sheet B

	B	C
1	Product	id
2	Table	2
3	Book	2
4	Phone	1
5	Table	1
6	Phone	2
7	Phone	3
8

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4