Your are viewing a read-only archive of the old DiS boards. Please hit the Community button above to engage with the DiS !
i'm not explaining this well. it's multiple functions. i like MATCH
It is all about index and match
Usually a whatchamacallit with the curly brackets can achieve the same result far more elegantly. Array formula.
They're my favourites, array formulas. Not strictly speaking a function however.
they don't call them FUNctions for nothing
Not used that in years, it was alright, that matlab
Not SUM, not SUMIF, SUMIFS
Sumproduct is possibly stronger too
also a doozy
The tryhard indie bellsniff's VLOOKUP.