Forum Discussion
VK01852395
Jun 15, 2024Copper Contributor
complex questionnare in excel
In an excel, I am having a quiz, but complication is that each question has different options and hence difference score. So each question can have one answer and based on selection, there is a score...
- Jun 15, 2024
I'd repeat the question numbers, and convert the range to a table:
I named the table Scores.
You can then use an INDEX/MATCH formula:
The formula in C2 is
=INDEX(Scores[Score], MATCH(1, (Scores[Question]=A2)*(Scores[Option]=B2), 0))
This can be filled down.
HansVogelaar
Jun 15, 2024MVP
I'd repeat the question numbers, and convert the range to a table:
I named the table Scores.
You can then use an INDEX/MATCH formula:
The formula in C2 is
=INDEX(Scores[Score], MATCH(1, (Scores[Question]=A2)*(Scores[Option]=B2), 0))
This can be filled down.
- VK01852395Jun 16, 2024Copper ContributorWorked like charm! You made it simple for me. I learnt a think or two. Thank you very much.