Index and If formula together with two criteria?

[Excel43]

Hi,

I would like to know how I can make this formula to use two criteria:

=IFERROR(INDEX(Vikta;SMALL(IF(Vikta[Grupper]=1;ROW(Vikta)-4);ROW(2:2));1);"")

I have tried this but it gives me a a "#SPILL" error:

=IFERROR(INDEX(Vikta;SMALL(IF(AND(Vikta[Grupper]=1;Vikta[Grupp]=I3);RAD(Vikta)-4);RAD(1:1));1);"")

 

[Excel43]

Ooops, the last one should say "ROW" instead of "RAD". Translating it from Swedish

 

[AhoyNC]

Maybe something like this where you nest two IF functions instead of the AND.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.

IFERROR(INDEX(Vikta;SMALL(IF(Vikta[Grupper]=1;IF(Vikta[Grupp]=I3;RAD(Vikta)-4));RAD(1:1));1);"")

 

[Excel43]

Thanks AhoyNC! It works great! I change the code a bit and would now need to nest the function with similar ones. Do you know if it is possible to nest it? I tried this, but it gives me errors:

=INDEX(Vikta;SMALL(IF(Vikta[Grupper]=1;IF(Vikta[Grupp]=I3;ROW(Vikta)-4));ROW($1:$1));27;INDEX(Vikta;SMALL(IF(Vikta[Grupper]=2;IF(Vikta[Grupp]=I3;ROW(Vikta)-4));ROW($1:$1));27))

 

[Excel43]

I solved it. Did it this way:

=INDEX(Vikta;MINSTA(OM(Vikta[Grupp]=I3;OM(Vikta[Grupper]=1;RAD(Vikta)-4);OM(Vikta[Grupper]=2;RAD(Vikta)-4));RAD($1:$1));27)