Advanced drop-down menu

[amir9s]

I'm trying to create drop-down list that automatically detects which list it should put in a cell. here's an example to show what I exactly mean:

Sheet1:

1	2	3	4
a1	ff	sdf 45 hg	3 t 67 sdf
bsg tjn 33	f 5 hh sd	d2 2	eg sd2
22 33r sdr	f4rh tg l3		d ff 3287 ff
	wr 46 t68jd		s47h vf 44 234
	f378g jj 5
	33 t

<tbody>
</tbody>

<colgroup><col span="4"></colgroup><tbody></tbody>

Sheet2:

Number	Code

<tbody>
</tbody>

column 1 of each sheet is the title column.
What I'm trying to do is to have drop-down menu under the Code column on sheet2 that corresponds to the Number column to its left.
So if I type "1"(or "2" or "3" or "4"), it takes all the values under column "1" (or "2" or "3" or "4") of sheet1 and list them in a drop-down menu for me in the cell below "Column" title cell.
Is this even possible? Thank you.

 

[jorismoerings]

Hi,

That's possible using Data validation lists.

See this link for a full explanation of the techniques : Dependent Drop-down Lists in Excel - Easy Excel Tutorial

see this thread for earlier answers : http://www.mrexcel.com/forum/excel-questions/944135-data-validation-dependent-list.html

and here's my testmodel: https://app.box.com/s/sea5sxufbcbv4eju3ir3zqaqnb1fhs44