Create a List Based Data from another Tab

[Papa_Don]

Group,

I have a table (Sheet1) in Excel that looks something like this:

[TABLE="class: grid, width: 250, align: center"]
<tbody>[TR]
[TD="align: center"]Numbers[/TD]
[TD="align: center"]Type[/TD]
[/TR]
[TR]
[TD="align: center"]123[/TD]
[TD="align: center"]TK[/TD]
[/TR]
[TR]
[TD="align: center"]123[/TD]
[TD="align: center"]TQ[/TD]
[/TR]
[TR]
[TD="align: center"]123[/TD]
[TD="align: center"]HK[/TD]
[/TR]
[TR]
[TD="align: center"]208[/TD]
[TD="align: center"]TK[/TD]
[/TR]
[TR]
[TD="align: center"]208[/TD]
[TD="align: center"]TQ[/TD]
[/TR]
[TR]
[TD="align: center"]208[/TD]
[TD="align: center"]HQ[/TD]
[/TR]
[TR]
[TD="align: center"]208[/TD]
[TD="align: center"]HK[/TD]
[/TR]
[TR]
[TD="align: center"]208[/TD]
[TD="align: center"]DK[/TD]
[/TR]
[TR]
[TD="align: center"]208[/TD]
[TD="align: center"]DQ[/TD]
[/TR]
</tbody>[/TABLE]

On a separate tab (Sheet2) within the same spreadsheet, I want to be able to enter the "Number" and return each of the available "Types". By this I'm saying I want it to return something that looks like this:

[TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
[TD="align: center"]Number ID[/TD]
[TD="align: center"]123[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]TK[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]TQ[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]HK[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
[TD="align: center"]Number ID[/TD]
[TD="align: center"]208[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]TK[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]TQ[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]HQ[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]HK[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]DK[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]DQ[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

If I were building a list box, I know how to do that. However finding the data based on the Number ID and putting the available types below it is something I've not done.

Can you offer some suggestions as to how?

Thanks,

Don

 

[Weazel]

something like...

Excel 2012[TABLE="class: grid, width: 500"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFFF00"]Numbers[/TD]
[TD="bgcolor: #FFFF00"]Type[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00"]Number ID[/TD]
[TD="bgcolor: #FFFF00, align: right"]123[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: right"]123[/TD]
[TD]TK[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]TK[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]123[/TD]
[TD]TQ[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]TQ[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]123[/TD]
[TD]HK[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]HK[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]208[/TD]
[TD]TK[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]208[/TD]
[TD]TQ[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]208[/TD]
[TD]HQ[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]208[/TD]
[TD]HK[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]208[/TD]
[TD]DK[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]208[/TD]
[TD]DQ[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]E2[/TH]
[TD="align: left"]{=IFERROR(INDEX(Sheet1!$B$2:$B$10,SMALL(IF(Sheet1!$A$2:$A$10=$E$1,ROW(Sheet1!$A$2:$A$10)-ROW(Sheet1!$A$2)+1),ROWS($E$2:E2))),"")}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]