Forum Discussion

VK01852395's avatar
VK01852395
Copper Contributor
Jun 15, 2024

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...
  • HansVogelaar's avatar
    Jun 15, 2024

    VK01852395 

    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.

     

Resources