However, if you try this, the INDEX function will return only one result SUM.
For a good write up on this behavior, seethis article by Jeff Weiron the StackOverflow site.
you’ve got the option to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
The N function can be used to convert TRUE and FALSE to 1 and 0 respectively.
When given a text value, the N function returns zero.
