The MATCH function returns the position of a value (in a list, table, database). And, the INDEX-MATCH functions used together make extracting data from a table a breeze.

Functions that return multiple values are hard to name clearly. It's easy to mistake the order of the return values. (password, username) = GetUsernameAndPassword() ...