Formula to return data if it matches row and column

[macroos]

Hi,

I have a set of data here.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]5/1/18[/TD]
[TD]6/1/18[/TD]
[TD]7/1/18[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]U1[/TD]
[TD]50[/TD]
[TD]40[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]U2[/TD]
[TD]40[/TD]
[TD]30[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]U3[/TD]
[TD]30[/TD]
[TD]20[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]U4[/TD]
[TD]20[/TD]
[TD]10[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]










In this table below, I want to have formulas in the empty cells to give me the values that matches row that contains U1 and U3 and column that contains 5/1/18 and 6/1/18.
So it should give me values that are in red in the table above.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]5/1/18[/TD]
[TD]6/1/18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]U1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]U3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]






Thanks for your help in advance and I hope my question is not confusing.

 

[jtakw]

Hi,

Do you mean this:

Book1
	A	B	C	D
1		5/1/2018	6/1/2018	7/1/2018
2	U1	50	40	30
3	U2	40	30	20
4	U3	30	20	10
5	U4	20	10	0
6
7
8		5/1/2018	6/1/2018
9	U1	50	40
10	U3	30	20
Sheet184

Cell Formulas
Range	Formula
B9	=SUMPRODUCT(($A$2:$A$5=$A9)*($B$1:$D$1=B$8)*$B$2:$D$5)

Formula copied down and across.

 

[macroos]

Yes! Thank you so much!!!

 

[jtakw]

You're welcome.