index with multi criteria

[MRozell]

I can index with 1 criteria but when I try adding a second having trouble.

I have 1st criteria already in play. I am indexing names if they belong the team marked in E1.
{=IFERROR(INDEX(Table1[Name], SMALL(IF($E$1=Table1[Team], ROW(Table1[Team])-ROW($A$2)+1), ROW(1:1))),"")}

I want to add a 2nd criteria if Table1[No.] is >0

Right now it is returning Judy, Linda, Mike, and Tim

With the 2nd criteria should only return Judy and Mike

[ben_hensel]

You need to add an AND term to the first part of the IF. I don't think an actual AND would work though (the array would interpret it wrong), so accomplishing it algebraically:

Please Login or Register  to view this content.