Vlookup, code help

[Harrywatson]

I explained this question badly intitially. I have now added my data in table form.

[HTMLExcel 2012

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1298	2170	14/05/2014	UK12443760071508042013MSTX 01	UK124437	600715	08-04-2013	M	STX	£720	17 months, 3 days		08/08/2014	BU	SKIPTON
1299	2171	14/05/2014	UK12459330121312072013MLIMX 01	UK124593	301213	12-07-2013	M	LIMX	£885	13 months, 30 days		12/11/2014	BU	SKIPTON
1300	2172	14/05/2014	UK12486430057217052013MLIMX 01	UK124864	300572	17-05-2013	M	LIMX	£900	15 months, 25 days		17/09/2014	BU	SKIPTON
1301	2173	14/05/2014	UK12486430059318072013MLIMX 01	UK124864	300593	18-07-2013	M	LIMX	£925	13 months, 24 days		18/11/2014	BU	SKIPTON
1302	2174	14/05/2014	UK12495660038813062013MBAX 01	UK124956	600388	13-06-2013	M	BAX	£890	14 months, 29 days		13/10/2014	BU	SKIPTON
1303	2175	14/05/2014	UK12510170077719052013MCHX 01	UK125101	700777	19-05-2013	M	CHX	£840	15 months, 23 days		19/09/2014	BU	SKIPTON

<tbody>
</tbody>

ON 13-14​

Worksheet Formulas Cell Formula A1298 =A1297+1 B1298 =B1297 A1299 =A1298+1 B1299 =B1298 A1300 =A1299+1 B1300 =B1299 A1301 =A1300+1 B1301 =B1300 A1302 =A1301+1 B1302 =B1301 A1303 =A1302+1 B1303 =B1302 D1298 =LEFT(C1298,8) E1298 =MID(C1298,9,6) F1298 =TEXT(MID(C1298,15,8),"00-00-0000") G1298 =MID(C1298,23,1) H1298 =MID(C1298,24,LEN(C1298)-26) D1299 =LEFT(C1299,8) E1299 =MID(C1299,9,6) F1299 =TEXT(MID(C1299,15,8),"00-00-0000") G1299 =MID(C1299,23,1) H1299 =MID(C1299,24,LEN(C1299)-26) D1300 =LEFT(C1300,8) E1300 =MID(C1300,9,6) F1300 =TEXT(MID(C1300,15,8),"00-00-0000") G1300 =MID(C1300,23,1) H1300 =MID(C1300,24,LEN(C1300)-26) D1301 =LEFT(C1301,8) E1301 =MID(C1301,9,6) F1301 =TEXT(MID(C1301,15,8),"00-00-0000") G1301 =MID(C1301,23,1) H1301 =MID(C1301,24,LEN(C1301)-26) D1302 =LEFT(C1302,8) E1302 =MID(C1302,9,6) F1302 =TEXT(MID(C1302,15,8),"00-00-0000") G1302 =MID(C1302,23,1) H1302 =MID(C1302,24,LEN(C1302)-26) D1303 =LEFT(C1303,8) E1303 =MID(C1303,9,6) F1303 =TEXT(MID(C1303,15,8),"00-00-0000") G1303 =MID(C1303,23,1) H1303 =MID(C1303,24,LEN(C1303)-26) J1298 =DATEDIF(F1298,NOW(),"m") &" months, " & DATEDIF(F1298,NOW(),"md") &" days " K1298 =IF(IFERROR(VLOOKUP(A1298,'OFF 13-14'!A:A,1,0),0)='ON 13-14'!A1298,"✓","") L1298 =EDATE(F1298,16) J1299 =DATEDIF(F1299,NOW(),"m") &" months, " & DATEDIF(F1299,NOW(),"md") &" days " K1299 =IF(IFERROR(VLOOKUP(A1299,'OFF 13-14'!A:A,1,0),0)='ON 13-14'!A1299,"✓","") L1299 =EDATE(F1299,16) J1300 =DATEDIF(F1300,NOW(),"m") &" months, " & DATEDIF(F1300,NOW(),"md") &" days " K1300 =IF(IFERROR(VLOOKUP(A1300,'OFF 13-14'!A:A,1,0),0)='ON 13-14'!A1300,"✓","") L1300 =EDATE(F1300,16) J1301 =DATEDIF(F1301,NOW(),"m") &" months, " & DATEDIF(F1301,NOW(),"md") &" days " K1301 =IF(IFERROR(VLOOKUP(A1301,'OFF 13-14'!A:A,1,0),0)='ON 13-14'!A1301,"✓","") L1301 =EDATE(F1301,16) J1302 =DATEDIF(F1302,NOW(),"m") &" months, " & DATEDIF(F1302,NOW(),"md") &" days " K1302 =IF(IFERROR(VLOOKUP(A1302,'OFF 13-14'!A:A,1,0),0)='ON 13-14'!A1302,"✓","") L1302 =EDATE(F1302,16) J1303 =DATEDIF(F1303,NOW(),"m") &" months, " & DATEDIF(F1303,NOW(),"md") &" days " K1303 =IF(IFERROR(VLOOKUP(A1303,'OFF 13-14'!A:A,1,0),0)='ON 13-14'!A1303,"✓","") L1303 =EDATE(F1303,16) <tbody> </tbody>

<tbody>
</tbody>

][/HTML]

This is on the first sheet which is called "ON 13-14" this information is similiar all the way down this sheet for about 1500 rows.

My second sheet is blank.

What I would like on my second sheet is any rows of data on the first sheet (ON 13-14), where the date in column L is between two dates of my own choice.
Lets say i would like all rows (A-N) that have a date that is between 11/11/14 and 19/11/14 in column L to appear in the blank sheet.

So from the example i have given the rows that would then appear under the specification that i have given (The date in Column L is between 11/11/14 and 19/11/14) are as follows

Excel 2012ABCDEFGHIJKLMN1299217114/05/2014UK12459330121312072013MLIMX 01UK12459330121312-07-2013MLIMX£88513 months, 30 days 12/11/2014BUSKIPTON[CENTER][COLOR=#161120][B]ON 13-14[/B][/COLOR][/CENTER]

and

Excel 2012ABCDEFGHIJKLMN1301217314/05/2014UK12486430059318072013MLIMX 01UK12486430059318-07-2013MLIMX£92513 months, 24 days 18/11/2014BUSKIPTON[CENTER][COLOR=#161120][B]ON 13-14[/B][/COLOR][/CENTER]

I would like it so i can choose the two dates that i would like it to be between and then out of the thousand or so rows of data, say 40-50 appear on the second sheet where their contents in column L lies between the two dates I wish.

Help would be greatly appreciated.

Please feel free to ask questions.

Thanks

 

[Harrywatson]

The two that should be displayed where the HTML code has not quite worked are rows 1299 and 1301