Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup or Other Function?
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? |
#2
|
|||
|
|||
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 .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "bsleeth" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i use > in lookup function? | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Lookup Function Error | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions |