Excel Formula for an equation of permutation and combination

[Amolvks]

I have various options in the C2 cell as A,B,C & D (using list command in data validation). I have various options in cell D2 as 4,5,6. So I want to make formula for cell E2 in such a way that when A and 4 is selected in options it gives value 0.1. If A and 5 is selected, it gives 0.2. If B & 1 is selected it will give the value 0.6 and so on. All the permutations and combinations for the given columns in cell E2.
Please help with the formula.

 

[Special-K99]

"when A and 4 is selected in options it gives value 0.1"

Why would it do that?
Or any of the other combination that youve stated for that matter?

Where is your calculation to get 0.1 for A and 4?

Attach a spreadsheet or an image.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.