dropdown data

[reipanik]

hi guys im a noob in excel, but i would like to learn i am making this simple list but cant seem to make it work, so basically on the attached file, i a selection, what i want to do is basically when a specific part is selected the corresponding value on sheet 2 will come up. for example, pulling up charlie1 would give 100 on the next cell on sheet1 under value column...

i need this done as soon as possible.. any help would be appreciated