Can I create dropdown lists based on an array?

I need to create dropdown list based on the matrix below:

image description

So that I select the Urgency and the Impact and then the Priority is automatically filled according to the columns below:

image description

And if possible, could I take advantage of and already inherit color formatting from cells?

Could someone help me with this?