Hi,
I recently replaced someone at work and I'm trying to improve his spreadsheet but have no clue on how he derived his very complicated formula. This is ultra complicated to me.
=IF(F44<$D$10,0,IF(AND(F44>=$W$18,M44="Behavioural Term"),VLOOKUP(H44,INDIRECT(K44&"!$B$128:$CK$249"),MATCH('1 |...