Index/Match formula for specific date range?

[cyrous0425]

My sheet https://drive.google.com/open?id=1GoH102qo7XEY1pOD2x_Bvw9fkzPezLQ-. I really need you help guys. My problem is in my summary sheet I want to appear the PRN cell M3 if it has color within the specific date entered in J3&J7. Like the data I entered. I used helper sheet for my conditional formatting (color cell). Maybe there's a way to use the helper sheet to get the data but I don't know how to pull it. Thank you.

 

[Fluff]

I don't understand what you are looking for with this request.
But having had a quick look at your sheet you can do the Cf without the helper sheet like
=AND($C12="S/MGR",$D12<=K$11,$E12>=K$11)

 

[cyrous0425]

What I'm trying to accomplish Sir is if I entered date in column J3&J7 I want those PRN thas has color start from k12 with in the range of the date I entered to appear in column N.

 

[Fluff]

How about

Excel 2013/2016
	J	K	L	M	N	O	P	Q	R
2	START				PRN
3	10-Jan-2018				13003609
4					13003664
5	END				13001876
6					13004214
7	12-Jan-2018				13007068
8
Summary

Cell Formulas
Range	Formula
N3	{=IFERROR(INDEX($A$12:$A$17,SMALL(IF(($J$3<=$E$12:$E$17)*($J$7>=$D$12:$D$17),ROW($A$12:$A$17)-11),ROW(1:1)),1),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

But you will need to remove the merged cells in range N3:R8 as array formulae do not work in merged cells

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1078098-index-match-formula-specific-date-range.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).