VLOOKUP on Dates

[MikeyZ]

I know when you do a Vlookup on a date , say 4/16/1, it's going to pull the first one it finds and nothing else.
Suppose I have any number of lines showing a specific date, is there a way I can pull the sequential info from the cells in that column?

 

[wideboydixon]

My original solution adapted to suit:

=IFERROR(INDEX(POLINES!$AJ:$AJ,SMALL(IF(POLINES!$AL:$AL=$C$6,ROW(POLINES!$AL:$AL)),ROWS($D$6:$D6))),"")

Entered with Ctrl+Shift+Enter to create an array formula. Then copy it down the column as far as necessary.

This looks at the whole column so may be inefficient; it would be better to have a concrete range to work with.

WBD