Index-formula to ignore hidden (filtered out) cells

[Maartenengels]

Hi guys,

I have the following table with a few rows of data in it:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date submitted[/TD]
[TD]Driver[/TD]
[TD]Time spent with driver[/TD]
[TD]Leadership[/TD]
[TD]Communication[/TD]
[TD]Enthusiasm[/TD]
[TD]Commentary[/TD]
[TD]Environmental awareness[/TD]
[TD]Comments about driver[/TD]
[/TR]
[TR]
[TD]11/09/15[/TD]
[TD]Jan[/TD]
[TD]1-2 days[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]Good driver[/TD]
[/TR]
[TR]
[TD]10/11/15[/TD]
[TD]Cook[/TD]
[TD]3-10 days[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]Bad driver[/TD]
[/TR]
</tbody>[/TABLE]

My formula makes sure that in cell A5, in which I can select the driver, the Index-formula only shows data rows of the driver that is selected from a drop-down list. However, I have added a date filter to the sheet and can't get the formula to ignore the hidden rows a.k.a. the filtered rows. Any ideas on how to do this?

The formula is as follows:

{=IFERROR(INDEX(SurveyData[[#All],[Submitted]:[Comments]],SMALL(IF(SurveyData[[#All],[Driver]]=$A$5,ROW(SurveyData[[#All],[Submitted]])),ROW(1:1)),1)," ")}

Cheers,
Maarten