using validation to autofill cell

M

mugen

hi..

i have an excel sheet that i use validation to choose what i want to fill
cell with.
what i'd like to do is to autofill another cell based on what i pick from
the validation drop down list.

i have 2 lists

e.g. list1 list2
x 1
y 2
z 3

if from my drop down box i pick x i'd like cell B5 (for example) to show 1
and so on.

thanks in advance for any help
 
Top