I am trying to convert a flow chart into series of questions. Right now I
have a flow chart that asks a yes/no question. I would like to set up
something where it asks the first question and then if they answer yes, it
gives them the next question if no, then it asks a different questions. I can
do this for one question just using an IF statement but once I get to the
second question I am stuck since the second question will be different
depending on if the answer to the first was yes or no.
Any suggestions?

What does this have to do with VLOOKUP?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"jenhow" wrote:

I am trying to convert a flow chart into series of questions. Right now I
have a flow chart that asks a yes/no question. I would like to set up
something where it asks the first question and then if they answer yes, it
gives them the next question if no, then it asks a different questions. I can
do this for one question just using an IF statement but once I get to the
second question I am stuck since the second question will be different
depending on if the answer to the first was yes or no.
Any suggestions?

I thought that I might be able to list all of the questions in a table and
use VLOOKUP to pull the correct question. Not a good idea?

"Dave F" wrote:

What does this have to do with VLOOKUP?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"jenhow" wrote:

I am trying to convert a flow chart into series of questions. Right now I
have a flow chart that asks a yes/no question. I would like to set up
something where it asks the first question and then if they answer yes, it
gives them the next question if no, then it asks a different questions. I can
do this for one question just using an IF statement but once I get to the
second question I am stuck since the second question will be different
depending on if the answer to the first was yes or no.
Any suggestions?

Actually a VLOOKUP (or INDEX/MATCH) might be just the idea but a lot
depends on what you store where. The flow chart you are describing
seems like a tree, where the last question is the parent and correct/
incorrect are two paths stemming from the parent into the two children
questions. WHen storing graphs as tables (and trees in this case) the
following structure can work:

QuestionID ParentID Path Question
1 null null What is my name?
2 1 corr What is my last name?
3 1 incorr What is John's name?

The first question is the root hence has no parent or path. Questions
2 and 3 are the questions after 1 (whence their parentID) and you go
there for a correct or incorrect answer respectively. Thus, assuming
these data start from A2 (row 1 are headers), and if the last question
asked is in F2 and the answer (corr/incorr) is in G2, then you can
retrieve the next question with an *array* formula like:

=INDEX(D2:D20,MATCH(1,(B2:B20=F2)*(C2:C20=G2),0))

(since it is an array formula you have to commit with Shift+Ctrl
+Enter)

This is by no means a full solution to your problem but it might be a
start.

HTH
Kostis Vezerides

On Feb 23, 6:16 pm, jenhow wrote:
I thought that I might be able to list all of the questions in a table and
use VLOOKUP to pull the correct question. Not a good idea?

"Dave F" wrote:
What does this have to do with VLOOKUP?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"jenhow" wrote:

I am trying to convert a flow chart into series of questions. Right now I
have a flow chart that asks a yes/no question. I would like to set up
something where it asks the first question and then if they answer yes, it
gives them the next question if no, then it asks a different questions. I can
do this for one question just using an IF statement but once I get to the
second question I am stuck since the second question will be different
depending on if the answer to the first was yes or no.
Any suggestions?

Don't you think your INDEX/MATCH suggestion is more appropriate than VLOOKUP?
Seems it offers more flexibility.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"vezerid" wrote:

Actually a VLOOKUP (or INDEX/MATCH) might be just the idea but a lot
depends on what you store where. The flow chart you are describing
seems like a tree, where the last question is the parent and correct/
incorrect are two paths stemming from the parent into the two children
questions. WHen storing graphs as tables (and trees in this case) the
following structure can work:

QuestionID ParentID Path Question
1 null null What is my name?
2 1 corr What is my last name?
3 1 incorr What is John's name?

The first question is the root hence has no parent or path. Questions
2 and 3 are the questions after 1 (whence their parentID) and you go
there for a correct or incorrect answer respectively. Thus, assuming
these data start from A2 (row 1 are headers), and if the last question
asked is in F2 and the answer (corr/incorr) is in G2, then you can
retrieve the next question with an *array* formula like:

=INDEX(D2:D20,MATCH(1,(B2:B20=F2)*(C2:C20=G2),0))

(since it is an array formula you have to commit with Shift+Ctrl
+Enter)

This is by no means a full solution to your problem but it might be a
start.

HTH
Kostis Vezerides

On Feb 23, 6:16 pm, jenhow wrote:
I thought that I might be able to list all of the questions in a table and
use VLOOKUP to pull the correct question. Not a good idea?

"Dave F" wrote:
What does this have to do with VLOOKUP?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"jenhow" wrote:

I am trying to convert a flow chart into series of questions. Right now I
have a flow chart that asks a yes/no question. I would like to set up
something where it asks the first question and then if they answer yes, it
gives them the next question if no, then it asks a different questions. I can
do this for one question just using an IF statement but once I get to the
second question I am stuck since the second question will be different
depending on if the answer to the first was yes or no.
Any suggestions?

Hi Dave,

Yes, of course INDEX/MATCH is always more versatile... In this
particular case it seems to be necessary. Hard to go far with VLOOKUP
if you handle data like this.

Kostis

On Feb 23, 8:56 pm, Dave F wrote:
Don't you think your INDEX/MATCH suggestion is more appropriate than VLOOKUP?
Seems it offers more flexibility.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"vezerid" wrote:
Actually a VLOOKUP (or INDEX/MATCH) might be just the idea but a lot
depends on what you store where. The flow chart you are describing
seems like a tree, where the last question is the parent and correct/
incorrect are two paths stemming from the parent into the two children
questions. WHen storing graphs as tables (and trees in this case) the
following structure can work:

QuestionID ParentID Path Question
1 null null What is my name?
2 1 corr What is my last name?
3 1 incorr What is John's name?

The first question is the root hence has no parent or path. Questions
2 and 3 are the questions after 1 (whence their parentID) and you go
there for a correct or incorrect answer respectively. Thus, assuming
these data start from A2 (row 1 are headers), and if the last question
asked is in F2 and the answer (corr/incorr) is in G2, then you can
retrieve the next question with an *array* formula like:

=INDEX(D2:D20,MATCH(1,(B2:B20=F2)*(C2:C20=G2),0))

(since it is an array formula you have to commit with Shift+Ctrl
+Enter)

This is by no means a full solution to your problem but it might be a
start.

HTH
Kostis Vezerides

On Feb 23, 6:16 pm, jenhow wrote:
I thought that I might be able to list all of the questions in a table and
use VLOOKUP to pull the correct question. Not a good idea?

"Dave F" wrote:
What does this have to do with VLOOKUP?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"jenhow" wrote:

I am trying to convert a flow chart into series of questions. Right now I
have a flow chart that asks a yes/no question. I would like to set up
something where it asks the first question and then if they answer yes, it
gives them the next question if no, then it asks a different questions. I can
do this for one question just using an IF statement but once I get to the
second question I am stuck since the second question will be different
depending on if the answer to the first was yes or no.
Any suggestions?