I have a matrix I am building; there are 10 questions. The user selects
predetermined values for each of the 10 questions based on a Validated List.
I want the results column to return a value that is associated with that
answer.

Technical Details:
The workbook has three worksheets: Questionaire, Answers, Value
There are 10 columns on Answer, one for each question
There are 10 columns on Weight, one for each answer
Questionaire has three columns: Question, Answer, Value

Example
1) How often do you eat candy?
possible pop-down list answers are Daily, Weekly, Monthly, Never
possible values are 100, 50, 25, 0

The answer drop down is fed from the Answer Worksheet in A1-A5 titled aCandy.
The dropdown is a Validation List =aCandy
Value should pop with the value same location as the approriate answer but
on the value sheet.

Does this make sense?