Lookup or Other Function?

[Guest]

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?

 

[Max]

In sheet: Questionaire
---------------------------
Assuming the DVs for answers are in col B, B2 down
Put in C2: =INDEX(Value!A:A,MATCH(B2,Answers!A:A,0))
Copy C2 down

Col C will return the values corresponding to the answers selected in col B
from col A in sheet: Value

Adapt to suit ..