using validation to autofill cell

[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

 

[Debra Dalgleish]

You can use a VLookup formula to return the matching value when an item
is selected. There's information in Excel's Help, and here:

http://www.contextures.com/xlFunctions02.html

And for instructions for a sample order form that uses VLookups:

http://www.contextures.com/xlOrderForm01.html