Forum Discussion
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 Hi...
Formula uses names defined in Name Manager
In your own file you need to set the accordingly. Or use references instead.
How would I tweak the formula so that if there is no entry in the urgency or importance column, nothing shows up in the priority column?
jmdarbyshire , you are welcome
- Thank you very much for all your help Sergei. It works perfectly.
As variant
=IF( TRIM($C4) = "Ongoing", "Ongoing", IF( (TRIM($C4) = "")*(TRIM($D4) = ""), "", "Priority " & XLOOKUP( TRIM($D4), Importance, XLOOKUP( TRIM($C4), Sensivity, Priority, "not defined" ), "not defined") ))with