Score sheet

[DeletedAccount918]

I am currently working on a score sheet with list of question.

I have:
On Sheet 1 (will be hidden later)
List of 14 questions (e.g. question 1 = 6 possible answers, for answer 1 is score -2, for answer 2 is score 7... etc).
In column C are possible answers, in column D are the score values.

On Sheet 2 (will be visible for participants)
Drop-down list based on Sheet 1 questions (Sheet 1; Column C)
I have set Cell link for each question so when you choose the 3rd answer, there is number 3, but I need to set different values based on Sheet 1, could be that 3rd answer is score 12. I do not know which function to use (I tried IF, but to me it seems too long and difficoult).

Thanks in advance!
Tereza

 

[DeletedAccount918]

The picture:
http://www.clichy.estranky.cz/fotoalbum/umelecke-pokusy/smeska-starsich-fotografii/original/76

 

[Splith]

I greatly apologize for not getting to this and hopefully you have not given up on this forum hehe.

Okay what you want to do is for the cell that you want to compare data to you can do another Vlookup but for the sake of simplicity lets just do an if.

this will be placed in C19

=IF(I19>=120,"Approve",IF(I19>=90,"Grey Area","Decline"))

If you would like to learn how to do this with Vlookup just respond to this thread I would love to teach you.

~Splith

 

[DeletedAccount918]

Thanks a lot Splith for your answer! And no worries, for sure I will come back again with questions when I will have some excel troubles..
Have a nice day!