Drop down values relating to cells in next worksheet

[Guest]

Here goes, hope this makes sense! I have a worksheet that contains a
questionnaire, which is filled in by choosing the reply from the drop down
(Data/Validation) box, e.g. 'Strongly Agree', 'Disagree' etc. I need to be
able to make these choices relate to my scoresheet in the next worksheet, so
that when 'Strongly disagree' is chosen, a score of 10 is transferred to the
related cell in the scoresheet. There are 4 choices - strongly disagree =
10, disagree = 9, agree = 1, strongly agree = 0. I haven't a clue how to do
this, hope someone can help!

 

[Guest]

Hi
use vLOOKUP. e.g.
=VLOOKUP(A1,'other_sheet'!A1:20,2,0)

 

[R.VENKATARAMAN]

in sheet 2 -C4 to D8 are

answer marks
strongly disagree 10
disagree 9
agree 1
strongly agree 0

call this database for e.g. as "data"

in sheet 1 - the answers to your questions are there as follows in B6 to
D11

question no answer marks
1 strongly disagree
2 strongly agree
3 agree
4 disagree
5 strongly agree

in D7 type
=VLOOKUP(C7,data,2,FALSE)
you will get 10
copy D7 down upto D11
you will get the corresponding marks

D7 will be 10
D8 will be 0
D9 will be 1
D10 will be 9 and
D11 will be 0


may not be elegant but it works. I am sure you get the hang of it.

MAKE SURE that the spellings are same in both sheets.

 

[Guest]

Thats great, thanks muchly!

in sheet 2 -C4 to D8 are

answer marks
strongly disagree 10
disagree 9
agree 1
strongly agree 0

call this database for e.g. as "data"

in sheet 1 - the answers to your questions are there as follows in B6 to
D11

question no answer marks
1 strongly disagree
2 strongly agree
3 agree
4 disagree
5 strongly agree

in D7 type
=VLOOKUP(C7,data,2,FALSE)
you will get 10
copy D7 down upto D11
you will get the corresponding marks

D7 will be 10
D8 will be 0
D9 will be 1
D10 will be 9 and
D11 will be 0


may not be elegant but it works. I am sure you get the hang of it.

MAKE SURE that the spellings are same in both sheets.