New Formulas
=lookup()
Find the corresponding value of data by row. For example, look up a price of an automotive part by the part number. In this release you will only be able to do lookups on the same sheet as the =lookup() formula.
Until this function is usable across sheets, it is basically worthless.