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?
Bookmarks