Help With Formula Please

[nehpets12]

Need To Enter A Formula In G2

Book2
	A	B	C	D	E	F	G	H	I
1	Date	W/O	Customer		NoOfDateEntries	DatesWithCustomer	W/O
2	23/Oct	4273	Cleanaway	1	2	23/Oct	4270	1
3	21/Oct	4257	Ddd	2	1	21/Oct	4257	2
4	18/Oct	4270	Cleanaway	3	1	18/Oct	4273	3
5	30/Oct	4268	Cleanaway	4	1	30/Oct	4307	4
6	23/Oct	4307	Gulliver'S	5	2	23/Oct	4268	5
7	27/Sep			0	0	04/Nov	4311	6
8	27/Sep			0	0	15/Nov	4305	7
9	27/Sep			0	0	01/Nov	4274	8
10	27/Sep			0	0	13/Nov	4278	9
11	15/Oct			0	0	15/Nov	4211	10
12	04/Nov	4305	Ddd	6	1
13	15/Nov	4278	RmcPlantHire	7	2	WhatFormulaDoINeedInG1ToGetTheW/O
14	01/Nov	4311	HendyLennoxLtd	8	1	IcantUseVLOOKUPAsTheDatesAreDuplicated
15	13/Nov	4274	Cleanaway	9	1
16	15/Nov	4211	Ddd	10	2
17	30/Sep			0	0
18
19
Sheet1

 

[k209310]

ok what do you want the formula to do?

 

[nehpets12]

I have Put The Answers I Need In G2-G11

I need it to Match The Date In Column F and Lookup the W/O for that date my problem is that the dates could be the same so I then need the second match