Match date and name of master sheet and bring the data from second sheet column F

Try something like this...

Data Range

	A	B	C	D	E	F	G	H
1	------	------	------	------	------	------	------	------
2	1/1/2017	Blinp	10			1/1/2017	Blinp	10
3	1/5/2017	Hucca	50			1/2/2017	Ponk	20
4	1/2/2017	Ponk	20			1/3/2017	Doobie	30
5	1/3/2017	Doobie	30			1/4/2017	Rumo	40
6	1/4/2017	Rumo	40			1/5/2017	Hucca	50
7	1/6/2017	Sarm	60			1/6/2017	Sarm	60

This array formula** entered in C2 and copied down:

=INDEX(H$2:H$7,MATCH(1,(F$2:F$7=A2)*(G$2:G$7=B2),0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.