Create a List Based Data from another Tab

[Papa_Don]

Group,

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

Numbers	Type
123	TK
123	TQ
123	HK
208	TK
208	TQ
208	HQ
208	HK
208	DK
208	DQ

<tbody>
</tbody>

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:

Number ID	123
	TK
	TQ
	HK

<tbody>
</tbody>

Number ID	208
	TK
	TQ
	HQ
	HK
	DK
	DQ

<tbody>
</tbody>

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

	A	B	C	D	E
1	Numbers	Type		Number ID	123
2	123	TK			TK
3	123	TQ			TQ
4	123	HK			HK
5	208	TK
6	208	TQ
7	208	HQ
8	208	HK
9	208	DK
10	208	DQ

<tbody>
</tbody>

Sheet1​

Array Formulas Cell Formula E2 {=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))),"")} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>