Forum Discussion

DCBanks's avatar
DCBanks
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
PReagan's avatar
PReagan
Bronze Contributor
Nov 20, 2019

Hello DCBanks,

 

Unfortunately, AGGREGATE() does not allow wildcards. You may see which functions do allow wildcards here:

http://www.allerdrops.com/excel_help/functions/guide-to-excel-wildcards.htm

Resources