Dropdown Row + Dropdown Column = Data from Table

[steff13356]

Hello! I am trying to figure out a way to use two dropdowns based on the row and column headers in order to get a result that matches the info in a table.

This is the table in question:

So what I am trying to do, is to have one dropdown in a cell with the blue options on the left and one dropdown in a second cell with the beige options at the top. Selecting options in those dropdowns would return the result of the combination of the first two cells in a third cell.

Example:
Dropdown A selects: Likely
Dropdown B selects: Serious
Cell #3 shows result: B

Is is possible to achieve something like this? I'm fairly good with formulas and other than using 16 IF's to get all the possible results in a single formula, I was hoping to be able to find an easier way to do it.

Any help will be greatly appreciated!

 

[kevin9999]

Something like this perhaps?

steff13356.xlsx
	A	B	C	D	E	F
1	SEVERITY	Minimal	Moderate	Serious	Extreme
2	Highly Likely	C	B	A	A
3	Likely	C	C	B	A
4	Possible	D	C	B	B
5	Unlikely	D	D	C	C
6
7	Dropdown 1:	Likely
8
9	Dropdown 2:	Serious
10
11	Result:	B
12
Sheet1

Cell Formulas
Range	Formula
B11	B11	=INDEX($B$2:$E$5,MATCH(B7,$A$2:$A$5,0),MATCH(B9,$B$1:$E$1,0))

Cells with Data Validation
Cell	Allow	Criteria
B7	List	=$A$2:$A$5
B9	List	=$B$1:$E$1

 

[steff13356]

Yes! Thank you so much! I'll prepare my form and come back here if I have questions.

Greatly appreciated!

 

[kevin9999]

Yes! Thank you so much! I'll prepare my form and come back here if I have questions.

Greatly appreciated!

You're welcome, and thanks for the feedback.