Hi guys,

I tried some search, but since Im not a excel specialist a have hard time describing my problem through search.

Im making a 4x4 matrix where horizontal column can be defined by either 2 different criterias. In my case it is severity in terms of time or severity in terms of money lost. Vertical values are probabilities. I had an idea that I will have 3 dropdown menu's where these can be specified and matrix table would show the result in the matrix. I thought that maybe boolean values could be used for this, but then my inexperience with excel hit me. I tried couple ways how to do it but without success. Im doing this for my student project in risk management. I also attached a screenshot how it looks now, so the drop down menu's work but matrix doesnt.
excel.JPG

Thanks in beforehand for your help