Excel sheet making decision based on group of values



I need to make a decision based upon a bunch of values: My first excel sheet looks like this: Example:



Number Thing1 Thing2 Thing3 .... Thing7
1 0 1 0 1
2 1 1 0 0


I have another excel sheet that has the meanings associated with these values: Example:



Meaning Thing1 Thing2 Thing3 .... Thing7
Powerful 0 1 0 1
Medium 1 0 1 0
Low 1 1 0 0


Now I need to make a decision as to which number has what designation. The first sheet after processing should like this:



Number Thing1 Thing2 Thing3 .... Thing7 PowerLevel
1 0 1 0 1 Powerful
2 1 1 0 0 Low


Is this possible in excel ? If it is not then I am open to solutions from C# programming or any other language. Or maybe even an idea of how it can be done.


No comments:

Post a Comment