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?