Formula for a cell from four possible combos

[flavor1]

Excel.PNG
So I'm not sure if this is even possible...columns H-K have only 2 possibilities (High, Low), but only 2 of these columns will ever have a value in them, i.e. "Power" will be High, "Interest" will be High, the other 2 blank, or some other combination. I want a formula for column L that will auto-populate an entry in text format from 4 possible outcomes based on what is selected in columns H-K. For example:

1) Power=High, Interest=High, Influence=blank, Impact=blank therefore Category=Managed Closely
or
2) Power=High, Interest=Low, Influence=blank, Impact=blank therefore Category=Keep Satisfied
or
3) Power=Low, Interest=Low, Influence=blank, Impact=blank therefore Category=Keep Informed
etc.

Any hope in figuring this out?

[mo4391]

Assuming your data starts in row 2

Please Login or Register  to view this content.

[JohnTopley]

Please post a file with ALL conditions and expected results

[ChemistB]

There's only 3 but (assuming blanks are true blanks)

=IF(AND(ISBlANK(J2), ISBLANK(K2)), IF(H2="High", IF(I2="High", "Managed Closely", "Keep Satisfied"), IF(I2="High", ???, "Keep Informed")),"Something else")

??? represents low power, high interest
"Something else" represents J2 and K2 not being blank

[flavor1]

Thanks for the quick reply. I'll try it out and re-post.

[flavor1]

mo4391...That did the trick. Got some more to add to the formula for other combinations, but that was it. Thanks!

[mo4391]

No problem. Just trying to give back to the board that has helped me so much the last few years.