Drop down values relating to cells in next worksheet

A

AbbyLT

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!
 
A

AbbyLT

Thats great, thanks muchly!

R.VENKATARAMAN said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

creating a graph from a drop down menu 2
Drop down list control value in vba 2
How can I give a numerical value to a radio button? 4
How to make repeating drop-down lists? 2
How to get drop-down list to display text and #s but insert only # 0
How can I display text and #s in a drop-down list, but insert only 4
how to create a chart based on the content of a column 1
Possible? Variable X and Y data sources and Auto Charting 0

Top