Small function and row formula help

[matt85webb]

Hello, I have a formula and I have it working partially. The issues I have are that I need the row(1:1) to remain constant and not change. I need it to perform all 3 criteria:
1.If A3 is in 'Reg TOD Hours'!$B$2:$B$1000
2. B3 is in 'Reg TOD Hours'!$A$2:$A$1000
3. D2 is in 'Reg TOD Hours'!$C$2:$C$1000

I am trying to build it so that if ALL three criteria is met that it will pull the data in the 4th column over the hours column.

My setup for Reg TOD Hours is Column A: Date B: Client C: Code D: Hours
Here is the formula: =INDEX('Reg TOD Hours'!$B$2:D$1000,SMALL(AND(MATCH($A3,'Reg TOD Hours'!$B$2:$B$1000,0),MATCH($B3,'Reg TOD Hours'!$A$2:$A$1000,0),MATCH($D$2,'Reg TOD Hours'!$C$2:$C$1000,0)),ROW(1:1)),3)

[Tony Valko]

Maybe this array formula**:

=INDEX('Reg TOD Hours'!D:D,SMALL(IF('Reg TOD Hours'!B$2:B$1000=A$3,IF('Reg TOD Hours'!A$2:A$1000=B$3,IF('Reg TOD Hours'!C$2:C$1000=D$2,ROW('Reg TOD Hours'!D$2:D$1000)))),ROWS(A$1:A1)))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.