I'm a fairly new user to excel and was able to create an index table based on
2 constants. However, I believe to do what I'm looking for, I will need more
than 2 constants. For example, I need:

IF A and B and C, bring back 1. I can't use an if statement b/c there is
far more than 7 choices. (Person will select A,B,C from drop down lists)

Can anyone explain if/how to use an index table using more than 2 constants.