looking for a formula in a multiple choice question bank

[orinew1324]

Hey there!
First things first- I want to thank you for helping me with the matter at hand.
To summarize the issue:
I have an excel file that contains within it a bank of multiple choice questions and it looks somewhat like that:

there are 4 columns for each answer: answer0id, answer1id, answer2id and answer3id.
next to each of these, there are additional rows that indicate if the answers are correct or false.
for example, in the first row , we can see that the correct answer is answerid2 (which is practically answer number 3) since the row next to it shows the number "1", and all the other questions are false since the row next to them shows the number "0".
In order to import this question bank to a website Im building, I want an additional row that would tell me the right answer based on the binary system shown above.
is there any formula that could scan all these lines and provide the correct answer for each line, without having to do it manually?
thanks in advance,
Ori.

 

[Peter_SSs]

Welcome to the MrExcel board!

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. It would also make it easier to see exactly what those headings are.

In any case, try something like this.

=INDEX(M$1:Y$1,MATCH(1,P2:AB2,0))

BTW, rows run across the sheet and columns run down the sheet. I think you have your terminology a little confused which in turn can confuse your potential helpers.

 

[orinew1324]

Welcome to the MrExcel board!

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. It would also make it easier to see exactly what those headings are.

In any case, try something like this.

=INDEX(M$1:Y$1,MATCH(1,P2:AB2,0))

BTW, rows run across the sheet and columns run down the sheet. I think you have your terminology a little confused which in turn can confuse your potential helpers.

it worked !! thanks alot!
and about the rows and columns, thanks for reminder! haha
what a lovely community,
be safe in these troubled times,
Ori.

 

[Peter_SSs]

it worked !! thanks alot!
and about the rows and columns, thanks for reminder! haha
what a lovely community,
be safe in these troubled times,
Ori.

You're welcome. Glad it helped. We try to make this a very friendly forum.

Working from home in an online forum like this is a safe place to be currently!