If Match Multiple Criteria

[danieldors]

Hello,

I'm trying to return a list of cases which fall in the criteria below:

Unrun_Drivers=1

Time Standard=7

Expedited= N or A

Action= Application or Additional Benefits.

I tried if match but that didnt work. Thank you for any help.

=If(Match(Unrun_Drivers='1',[Time standard]='7',[Expedited]='N','A',[Action]='Application','Additional Benefits'),([Access Number]))

[GaryGiles · Accepted solution]

Try using set analysis criteria and the aggr() function, something like this:

=aggr(only({$<[Unrun_Drivers]={'1'},[Time standard]={'7'},[Expedited]={'N','A'},[Action]={'Application','Additional Benefits'}>} [Access Number]), [Access Number])

[danieldors]

Thank you