Once Criteria 1,2 and 3 are entered by the user in the table on the right, I need the code to automatically populate. Didn't think this was too hard but can't quite get it to work.
Can you please solve for an Excel 2019 user.
Can you please solve for an Excel 2019 user.
Book2 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
1 | Desired | |||||||||||
2 | Code | Criteria 1 | Criteria 2 | Criteria 3 | Criteria 1 | Criteria 2 | Criteria 3 | Code will be | ||||
3 | A | High | 1 | 1 | Medium | 1 | 1 | B | ||||
4 | B | Medium | 1 | 1 | ||||||||
5 | C | Low | 1 | 2 | ||||||||
6 | D | Medium | 2 | 1 | ||||||||
Sheet1 |