# Thread: Index/Match formula for specific date range? Thanks:  1 Post #5179261 (1) Likes: 0

1. ## Index/Match formula for specific date range?

Good day guys. I have a sheet like this https://imgur.com/a/OXju6Bg. Is this possible when I entered date in cell E2&E3 I want the names in the range date that I entered with the value of 1 to appear in cell H3? Thanks

2. ## Re: Index/Match formula for specific date range?

BCDEFGHIJKLMNOPQR
219-Nov-18name
324-Nov-18george
4paul
5drake
6john
7
811/19/201811/20/201811/21/201811/22/201811/23/201811/24/201811/25/201811/26/201811/27/201811/28/201811/29/201811/30/201812/1/201812/2/201812/3/201812/4/2018
9george1111
10paul1111111111
11drake11111
12john11111111111
13kenneth111111
14roy11111

Sheet1

In I3 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX(\$B\$9:\$B\$14,SMALL(IF(FREQUENCY(IF(\$C\$8:\$R\$8>=\$E\$2,IF(\$C\$8:\$R\$8<=\$E\$3,IF(\$C\$9:\$R\$14=1,MATCH(\$B\$9:\$B\$14,\$B\$9:\$B\$14,0)))),ROW(\$B\$9:\$B\$14)-ROW(\$B\$9)+1),ROW(\$B\$9:\$B\$14)-ROW(\$B\$9)+1),ROWS(\$1:1))),"")

3. ## Re: Index/Match formula for specific date range?

Good Day Sir would you mind looking to my entire sheet because I modify it. Here it is https://drive.google.com/open?id=1Go..._Bvw9fkzPezLQ-. So basically I need to do the same. I want in my summary sheet to appear the names with in the date range. Thank you so much.