Google Spreadsheets has an outstanding feature hidden in the depths of its help pages.
It’s called GoogleLookup.
How does it work? Try this:
Open a Google Spreadsheet
Type Denmark in A2, France in A3 and Turkey in A4
Select A2:A4.
Holding the Ctrl (Win, Linux) or Ctrl+Option (Mac) button expand that selection by dragging the small blue square in the lower-right [...]
