Formula based on a combination of two other cells where the combination varies
Hello forum friends
I need a formula that will look at two other cells and depending on the combination in those cells populate the third cell. For example:
If A1 says Critical and B1 says High then C1 will = Priority 1.
For example, the combinations will be as follows:
A1B1C1 (cell with the formula)CriticalHighPriority 1Critical MediumPriority 2Critical LowPriority 3Urgent High Priority 1Urgent MediumPriority 2Urgent LowPriority 3RoutineHighPriority 2Routine MediumPriority 3Routine LowPriority 4
Thanks in advance for your help!
Hello forum friends I need a formula that will look at two other cells and depending on the combination in those cells populate the third cell. For example: If A1 says Critical and B1 says High then C1 will = Priority 1.For example, the combinations will be as follows:A1B1C1 (cell with the formula)CriticalHighPriority 1Critical MediumPriority 2Critical LowPriority 3Urgent High Priority 1Urgent MediumPriority 2Urgent LowPriority 3RoutineHighPriority 2Routine MediumPriority 3Routine LowPriority 4 Thanks in advance for your help! Read More