Thanks for the suggestions! I got the VLOOKUP to work. I couldn't get the
LOOKUP option to work, but no doubt that was user error.

Thanks!

--
Cynthia


"CynthiaF" wrote:

I have a graphical decision tree that I use to estimate work effort based on
three decision points. The combination of points and responses results in 18
possible answers (work effort estimates). I'm trying to find a way to
automate this in an Excel spreadsheet of projects.

What I currently have are the three decision points as three drop-downs
based on lists I've set up on a separate worksheet. The options a

Column A = Possible answers are High, Med, and Low
Column B = Possible answers are Yes, No
Column C = Possible answers are High, Med, Low

What I'd like to do is evaluate the answers selected in A, B, and C and
populate a Column D with the value provided on the decision tree. (Note that
at this point I don't have those 18 values stored anywhere in the XLS.)

Note that any one selection does not impact the other selections - they are
mutually exclusive. Hence the possible 18 combinations/results.

The only way that I know to do this is with an IF statement (i.e. IF A=High
and B=Yes and C=High then populate D with 400) where I would have to provide
all of the decision tree values for each combo. But I'm not particularly keen
on writing an 18 argument IF statement.

I'm guessing there is some more efficient way to do this, but I have no idea
what it might be. I've looked at some of the other functions and can't see
how they would achieve what I'm looking for.

Thanks in advance for assistance!
--
Cynthia