Index Match Help

[ScabbyDog]

I have a bunch of dates in Column B. In Cell X1 I have used a formula to find the next date in the future from column B. I have used the index match formula to find the next date in the list and then to tell me what is in the cell to the left of it. However, sometimes there will be numerous equal dates as in the next date the index match is finding might be the 20th July and there might be up to 10 different instances of the 20th July in column B. How can I get the formula to return all 10 results instead of just the first one it comes across?

[Fotis1991]

Perhaps using a compination of INDEX & SMALL(IF using an ARRAY formula. But it's better to upload a small sample workbook.

[ScabbyDog]

SampleINDEXMATCH.xlsx

Here you go. As you will see the next date is 19th July 2013 and this corresponds with the letter G. However, there are numerous other 19th of Julys and I too would like them listed down the page one by one.

[Fotis1991]

In I20, use this ARRAY formula. Copy down.

=IFERROR(INDEX($A$2:$A$1000,SMALL(IF($B$2:$B$1000=$H$20,ROW($A$2:$A$1000)-1),ROW(A1))),"")

-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.