Forum Discussion

Copper Contributor

Nov 20, 2019

AGGREGATE function, criteria ignores wildcards

I am using AGGREGATE function and trying to get one of the criteria do do a wildcard lookup, this is the code: =IFERROR( INDEX(C$5:C$38, AGGREGATE( 15, 6, 1/(**bleep**=$O$10)/(Budget=$P$10)/(Project...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Nov 20, 2019

DCBanks

You may change this your criteria

(ProjectCode="*"&$Q$10&"*")

on something like

((ProjectCode=$Q$10)+($Q$10=""))

or use instead of blank whatever text you wish. With it in Q10 it will show all project codes.