Re: flow chart vlookup if statements

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 <jen...@xxxxxxxxxxxxxxxxxxxxxxxxx> 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?


.

Relevant Pages

  • Re: all foreign key should have index?
    ... Frank, you have a point in that I did not answer the first question the ... Also where the parent ... child table the more usful an index on the FK column becomes as Frank ...
    (comp.databases.oracle.server)
  • k2 questions.
    ... my first question is: has anyone here personal experience with k2 visa ... of small child, and if you are willing to share it. ... parent, should he/her be included on the affidavit of support ... -since you have to count household members, ...
    (misc.immigration.usa)
  • Re: bit of help with a couple of pieces of code
    ... Fletcher Glenn wrote: ... > To your first question, insert some form of the waitsystem ... > call for the parent case in front of the parent's printf. ...
    (comp.unix.programmer)
  • Re: Why not use forms ParentFont for Vista?
    ... In answer to your first question, the main form does not have a parent ... I made a small test program that just printed the name of the font for ... font than when run under XP. ...
    (borland.public.delphi.non-technical)