NEED HELP with MULTIPLE IF STATEMENTS

[dset64]

https://www.dropbox.com/sh/swp4v4fhdik3sf2/W2hUtRU3Vh

Above is the Dropbox link to my question. Below is a list of all questions, and IF(THEN statements. If the cell to the top left that currently says "Question 1" reads a certain question, the box changes from FALSE to the Question.

The HIGHLIGHTED box is my problem. When I say "Question 5" I want question to appear next to it.

THE FORMULA ABOVE ALREADY WORKS FINE WITH THE FIRST 2 QUESTIONS. My problem is how do I do more?

ANYBODY KNOW HOW TO DO AN IF(AND(AND(AND(AND(etc. statement? OR an IF(OR(OR(OR(OR(etc. statement??? HELP!

 

[mzi]

Suppose your question number is in Cell B2 and your question lookup table is in range B4:C13 then

Use this formula in Cell C2...
=IFERROR(VLOOKUP(B2,B4:C13,2,0),"")

and just change the question number in Cell B2 and in the next cell the question will appear according to your question number...
Hope this will work for you, Best of Luck...

 

[Asala42]

For some reason your screenshot is blurry on my screen

What is your objective?
Are you just trying to bring over the question text given an entry of a nearby question number? If this is the case, might be just shooting for a vlookup.

=VLOOKUP($A$11,$A$101:$B$200,2,0)

 

[dset64]

Hey Guys,

Thanks it was a VLOOKUP table I needed, I appreciate the help.