Afternoon Guys

Having a few problems with an Index formula.

I have a load of raw data and I want to pull each of the rows out with a certain criteria,

=INDEX(Installer,SMALL(IF($D$3=over14,ROW(over14)-MIN(ROW(over14))+1,""),ROW(A1)))

This formula pulls of each record that has a "1" in the over 14 array which works perfect, but I want to say:

IF(D3=over14)and(D4=unbilled)

(D3 and D4 are the cells with the criteria in, "over14 is the first array to look in and unbilled is the second array to look in)

is there a way I can put this into the above formula?

if you require an working example let me know

thanks