So, I have column 1 which has a dropdown of 6 values (i.e. 1-Very small, 2-Small) etc... and column 2 which has 6 different potential dropdown (i.e. 1-Simple, 2-Low Complexity) etc..
The user would select one in each column and i would like column 3 to then have a formula to work out a score (this is based on a 6x6 table matrix). For example, If Col1 is 1,2 or 3 AND col 2 is 1 or 2, then the value would bve "S1". If col1 was 3 and col 2 is 3 then it would be "s2" etc...
Cannot work out how to do this
The user would select one in each column and i would like column 3 to then have a formula to work out a score (this is based on a 6x6 table matrix). For example, If Col1 is 1,2 or 3 AND col 2 is 1 or 2, then the value would bve "S1". If col1 was 3 and col 2 is 3 then it would be "s2" etc...
Cannot work out how to do this