Help adding criteria to INDEX formula

Hi

i came up with this formula for a DB from my work

=IF(ISERROR(INDEX(Geral!$C$1:$L$100;SMALL(IF(Geral!$A$2:$A$100=$C$3;ROW(Geral!$A$2:$A$100));ROW(Geral!1:1));2));"";INDEX(Geral!$C$1:$L$100;SMALL(IF(Geral!$A$2:$A$100=$C$3;ROW(Geral!$A$2:$A$100));ROW(Geral!1:1));1))

but some changes came up and i need to upgrade it!

ATM the formula obeys to 1 search criteria in cell C3, but i need it to search for 3 criteria before returning the result.
Already tried some changes but unsuccessful

Can anyone give me an hand??
Thanks alot in advance

Your first condition is this:

Geral!$A$2:$A$100=$C$3

but to make this into multiple conditions you would put brackets around the conditions and join them together with the *, like this:

(Geral!$A$2:$A$100=$C$3)*(Geral!$B$2:$B$100>=$D$3)*(Geral!$B$2:$B$100<$D$3+10)

Obviously, I'm guessing what your conditions might be.

Hope this helps.

Pete

The easiest way is to apply a Custom Format to the cell of:

General;;

The two semicolons cause negative numbers and zeros to be displayed as blanks. If a negative number is a valid result for you, you can use:

General;-General;

Hope this helps.

Pete