Display one of four text strings depending on values from two cells

[DavidOswald]

Hi there.

I'm hoping someone can help here. I'm delivering some training where learners will be shown how to prioritise tasks. They will answer 2 questions that have 4 options each. Only one answer is required for each question. Depending on the combination of responses I want one of four text strings to be shown. Is this something that can be done in Excel? I made an online form with conditional logic that works. However, I want to try doing the same thing using Excel.

 

[Scott Huish]

Can you post the questions, options, and expected results?

 

[DavidOswald]

Sure thing. Thanks.

Okay so it's importance and urgency I'm interested in.
The first drop down question is importance. 4 options.
Option a1 Very high,
Option a2 Some impact,
Option a3 Little impact,
Option a4 No impact.

The second drop down question is urgency. 4 options.
Option b1 <24 hours,
Option b2 >24 hours <7 days,
Option b3 >7 days <31 days,
Option b4 >31 days.

I've done the easy part creating the dropdown lists.
Now I need a cell to display one of four options depending on the answer to the above two questions.
Option 1 - Do it now!
Option 2 - Schedule it
Option 3 - Delegate it
Option 4 - Eliminate it.

Basically, the results should follow the following logic:
a1 + b1 = do it now!
a1 + b2 = do it now!
a2 + b1 = do it now!
a2 + b2 = do it now!

a1 + b3 = Schedule it
a1 + b4 = Schedule it
a2 + b3 = Schedule it
a2 + b4 = Schedule it

a3 + b1 = Delegate it
a3 + b2 = Delegate it
a4 + b1 = Delegate it
a4 + b2 = Delegate it

a3 + b3 = Eliminate it
a3 + b4 = Eliminate it
a4 + b3 = Eliminate it
a4 + b4 = Eliminate it

I've tried to make this as clear as I can, but my head is spinning right now. Any help is gratefully received!

Thanks.

 

[Scott Huish]

I would make a table somewhere in your workbook with all the possibilities like I did in M1:Q5 and then use INDEX MATCH MATCH

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Importance	Urgency	Priority										Importance/Urgency	<24 Hours	>24 Hours <7 days	>7 days <31 days	>31 days
2	Very high	<24 Hours	Do It Now!										Very high	Do It Now!	Do It Now!	Schedule it	Schedule it
3	No Impact	>7 days <31 days	Eliminate It										Some Impact	Do It Now!	Do It Now!	Schedule it	Schedule it
4													Little Impact	Delegate It	Delegate It	Eliminate It	Eliminate It
5													No Impact	Delegate It	Delegate It	Eliminate It	Eliminate It
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=INDEX($N$2:$Q$5,MATCH(A2,$M$2:$M$5,0),MATCH(B2,$N$1:$Q$1,0))

Cells with Data Validation
Cell	Allow	Criteria
A2:A11	List	=$M$2:$M$5
B2:B12	List	=$N$1:$Q$1

 

[DavidOswald]

You're a total genius sir. Massively helped me out, works a treat.

Many thanks for your help.