GoogleLookup Gives Us Another Reason to Use (and Love) Google Docs
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).