I have 2 columns both with text. In column 1 each cell has the same 5 text options and in the other column each cell has 4 text options. There are 20 combinations of these cells. I have a matrix of these combinations that give 9 possible numerical value outcomes. How do I create a formula that in effect gives me one of the 9 values in a third column from the combinations I have in column 1 and column 2. I do not use excel often hence the question.

By: Huw Collins