ReadWriteWeb pointed us to a nifty function on Google Spreadsheets that we hadn’t used before: GoogleLookup, which essentially turns your spreadsheet cells into Google search boxes. To use it, you simply enter this formula into a cell on your spreadsheet:

Syntax: =GoogleLookup(“entity”; “attribute”)

where “entity” stands for the name of any subject/item you want information about (i.e. a famous person like Audrey Hepburn; a city like Taipei; a chemical compound like Isopropyl Alcohol) and “attribute” refers to the type of imformation you are trying to retrieve (like Hepburn’s date of birth; Taipei’s population; or the melting point of Isopropyl Alcohol).

This content is available for Basic Members.
Already a member, log in