drop down menue.

[needhelp2]

Hi all,

Dear i need to know how can i link some value to specific name.when ever i selet that name from drop down menu then value related to that name apeares in cell below.
E.g
name is in drop down adam

4510
4600
5106

apears in below of drop down.

can u tel me how can i do so?

 

[VoG]

Perhaps you mean a dependent list http://www.contextures.com/xlDataVal02.html

 

[needhelp2]

Dear peter i need to knw that how value apear right below if i select some name.
can i share file to you?