Copying contents of a cell based on a 'match' from two columns

[LMaeExcel]

Hello,

I am trying to collect data from different sheets into a table. I’dlike the table to auto-fill based on the date of the day, and matching the name. The formula shouldn’t count entries, but rather report or copy the number entered in the cell for that person on that date.

Example:

Table should populate from a sheet that looks something like this:

ORDERS​
	BILL​	JOHN​	GARY​
7/10/2018​	2​	4​	1​
8/15/2018​	2​	1​	2​
8/16/2018​	2​	1​	2​
8/17/2018​	1​	4​	3​
8/18/2018​	0​	0​	0​
8/19/2018​	0​	1​	0​
8/20/2018​	0​	3​	1​
8/21/2018​	2​	2​	1​
8/22/2018​	0​	8​	10​

<tbody>
</tbody>

And auto-fill the table that looks something like this:

8/22/2018​
	REFERRALS​	ORDERS​	OUTREACH​	COMPLETED ​
BILL
JOHN
GARY

<tbody>
</tbody>

So, if my formula were to be working properly with the example data above, my table would look like:

8/22/2018 ​
	REFERRALS​	ORDERS​	OUTREACH​	COMPLETED ​
BILL		0​
JOHN		8​
GARY		10​

<tbody>
</tbody>

Any help is greatly appreciated!

 

[jtakw]

Hi,

May be something like this may help:

Book1
	A	B	C	D	E
1	ORDERS
2		BILL	JOHN	GARY
3	7/10/2018	2	4	1
4	8/15/2018	2	1	2
5	8/16/2018	2	1	2
6	8/17/2018	1	4	3
7	8/18/2018	0	0	0
8	8/19/2018	0	1	0
9	8/20/2018	0	3	1
10	8/21/2018	2	2	1
11	8/22/2018	0	8	10
12
13
14	8/22/2018
15		REFERRALS	ORDERS	OUTREACH	COMPLETED
16	BILL		0
17	JOHN		8
18	GARY		10
Sheet199

Cell Formulas
Range	Formula
B16	=IF(B$15=$A$1,SUMPRODUCT(($A$3:$A$11=$A$14)*($B$2:$D$2=$A16)*$B$3:$D$11),"")