Formula to return specific values in a table by date

[mattbarbera]

Hi all

I've been trying to work out how to get the results highlighted in red in this Sheet

https://docs.google.com/spreadsheet...6sQor_y66N3TZbmX5in-jOz1olM/edit?usp=drivesdk

Just trying to get John's Dept and sales results ordered by date.
Not sure if it's an Index formula or not
Thanks!

 

[wideboydixon]

Book1
	A	B	C	D	E	F	G	H
1		Name	Dept	Sold			Dept	Sold
2	01/01/2017	John	501	28		John	501	28
3	03/01/2017	Steve	201	19			101	22
4	05/01/2017	John	101	22			301	30
5	07/01/2017	Larry	301	29
6	09/01/2017	Steve	401	21
7	10/01/2017	Mary	101	23
8	11/01/2017	John	301	30
Sheet2

Cell Formulas
Range	Formula
G2	{=IFERROR(INDEX(C$2:C$8,SMALL(IF($B$2:$B$8=$F$2,ROW($B$2:$B$8)-ROW($B$2)+1),ROWS(G$2:G2))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Copy formula in G2 across and down.

WBD

 

[mattbarbera]

Thanks wideboydixon, this worked a treat!