Messy Data- Have attempted using Index/Match, but there are multiple headings. need IF

Data.JPG

On the left hand side of the above image is the raw data I was given. The data is a mess and I am trying to reformat it. On the right is the setup I would like.

The data on the left is from a survey. For example for Question 3, the question is in yellow and the row below it includes options (Bank Account, RefWorks Account, ILLIAD account, Library Account). Below the options is the selection.
1 is the first option listed in the survey and would be the equivalent of an A in a scantron.

On the reformatted sheet on the right for cell D3 I used the following formula, referring to the raw data and using the equivalent of an H lookup:
=INDEX(Raw!$M$4:$M$22,MATCH(AdvForm!A3,Raw!$A$4:$A$22,0))

The problem with the above formula is that I am singling out one vertical column, I need a formula to match the row (respondent) to their answer within the cell range L:O.
Should I do a nested if statement? By Evaluating if the Index/Match displays the lookup value if not evaluate the next formula??
Please let me know what would work best?
This data is driving me crazy

If there is only going to be one answer per question you could use this formula:

Formula:

Please Login or Register  to view this content.

This finds the first non blank cell in the range. Hope this helps, but if there are multiple answers then only the first will be returned.

formula(isblank).JPG

i like that idea a lot, but for some reason I'm not able to get it to work.
I am receiving an N/A

Sorry should of said you need to Ctrl + Shift + Enter the formula

I hope that works

Perfect it worked! Sorry didn't realize it was an array. Thank you!

No problem - happy to help