Copy cell content based on criterias from one range to anoter

[Swissbandit1974]

Hi, i would like to duplicate the content of certain cells depending on some criterias. I tried VlookUp, Match and Index but i cant get it. If possible i prefer a solution without vb macros.

I try to explain using the below sample table

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Selection of Category (input)[/TD]
[TD]Categories
(given data)[/TD]
[TD]Available Types
(different within each category, given data)[/TD]
[TD]List of available choices
(output)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]USER INPUT (1 - 4)[/TD]
[TD]1[/TD]
[TD]TypeA[/TD]
[TD]list of all available types within the selected category[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]TypeB[/TD]
[TD]list of all available types within the selected category[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]TypeC[/TD]
[TD]list of all available types within the selected category[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]TypeD[/TD]
[TD]list of all available types within the selected category[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]TypeE[/TD]
[TD]....[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]TypeF[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]TypeG[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]TypeH[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]TypeI[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]TypeJ[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]TypeK[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]TypeL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]TypeM[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]TypeN[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]TypeO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]TypeP[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]TypeQ[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]TypeR[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]TypeS[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Please note that not all categories have the same amount of types within them. The name of all types howere is different.

desired Function:
The user can select a category in the filed A2
The table shall then list all vailable types of the seceted category in the column D.

If possible without macros

Your help yould be greatly apprechiated