Drop menus

[sludeking]

Hey,

I'm looking to make an excel spreadsheet with some features I'm not sure how to do.

Referring to the attached picture:

If we look at row 3 column 4 (Kode).

What i would like is to make a drop down menu with different values. (1-1000)

When i select one of the values, lets say 1;

columns 1, 3, and 5 will auto fill with data i have predetermined to be associated with the value 1.

I hope you understand what i mean.