Data Lookup with Google Spreadsheets

One of the advantages Google Spreadsheets has over a client-side spreadsheet such as Microsoft Excel, is access to live data look ups. Using the GoogleLookup function, data lookup for many kinds of standard facts is simple. Standard facts include, for example, population figures for cities and countries, capitals for states and nations, and places of birth for famous people. For exact syntax and more examples see the Google Docs & Spreadsheet Help Center .