Forum Discussion
Two formulas that work dont work when combined with IFs or IF
SergeiBaklan Formula A is =IFS(MATCH($AA15,$AJ$5:$AJ$14,0),INDEX(RA[FLOP],MATCH(1,(RA[TYPE]=$AA15)*(ABS((AVERAGEIF(RA[TYPE],$AA15,RA[EQUITY])-RA[EQUITY]))=AGGREGATE(15,6,1/(RA[TYPE]=$AA15)*(ABS(AV...
Dichotomy66 , if I understood correctly your formula looks like
=IFS(MATCH(<1>),<value 1>, MATCH(<2>), <value 2>)
IMHO, entire logic is incorrect. If you have no first match, MATCH(<1>) returns #N/A and entire formula also returns #N/A. If first matches, you calculate and return value 1. You may go on second match if only first one returns zero, but it can't return zero position.
If you want to check if MATCH finds something or not, use it in form
=IFS(ISNUMBER(MATCH(<1>)),<value 1>, ISNUMBER(MATCH(<2>)), <value 2>)